D
Dan
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
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