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

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