use sumif condition
=sumif(G:K,"<100) & =sumif(G:K,"150")



On Apr 3, 10:45*pm, CB wrote:
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?