Excel -change colour of certain cells in a table based on another cell value in the same table

Question

In the same sheet, I have a table (big data) lets say A1: AO300.But the data I am interested in to change cell colour is Range("G16:AK300") I have 4 rows and each row is allocated a cell value, example: cell(16,7)="SG1",cell(17,7)= "C1";cell(18,7)="ASB1" and cell(19,7)="H1"), this cells initially have a colour for each value. What I would like to do is when I have the codes/value "ESG1" in row 16; "EC1" in row 17; "EASB1" in row 18 and "EH1" in row 19 - these "E" codes could be in any column but only in the row corresponding the the value I told you ate the beginning, my question is what is the code vba and using vloop (I think) for changing automat the colour of cell containing (SG1 or C1 or ASB1 or H1) when I wrote in a different cell in the coresponding row the codes (ESG1 or EC1 or EASB1 or EH1). the first codes means something that I start and I need to follow . Everything with "E" code is meaning that I finished that task. So for example if I put the code "C1" in row 16 but could be in any column. after few day I ended that task and when I want to write "EC1" in the same row (different column) I would like automatically the cell with the value "C1" to change colour in green (meaning task done) And all the 4 line/rows at the beginning are repeating down for all data in the table. thats why I am thinking to use vba and vloop or something to repeat this comands for all table down. Not sure if make sense :)

Thank you in advance