I have a spread sheet that I am using 3 specific columns A, E, G.

if say cell "A5" is .font.colorindex=1 and "G5" is <=110 I need "E5"
..interior.Colorindex=36

A = ID number which are colored by ID type which is why I am using the font
color to differentiate.
E = Is an assignment number
G = A compleation number

Depending on type adjusts the <= in "G"

Since this needs done for each row I wasn't sure if or how to apply a
conditional format or the proper codeing. Thanks in advance