Conditional Format - Excel 2007
 

I want to color an entire row green where the value in column C = "Support".
I have selected condtional format use a formula to determine which cells
to format but am not getting consistent results so something must be
incorrect with the formula.

Thanks

Lisa

Conditional Format - Excel 2007
 

Hi Lisa

Depending upon the range you have selected, make the formula relate to the
first row in the range but keep the column absolute
=$C2="Support"

--
Regards
Roger Govier

"6538" wrote in message
...
I want to color an entire row green where the value in column C =
"Support". I have selected condtional format use a formula to determine
which cells to format but am not getting consistent results so something
must be incorrect with the formula.

Thanks

Lisa