I am using 2007.
My spreadsheet contains sales figures for the sales staff and is auto summed
for each sales person.
I need to conditional format G:K based on the word Total in Col A and The
cell values in Cols G:K.
So that for each row in col A that contains the word "Total", Excel will
format G:K based on their value.
If A contains "Total" set conditional fomat of G:K as follows:
If G:K < 100 Fill Color Green
If G:K 150 fill color Yellow
Can someone please help?