Conditional Format - Excel 2007

6

6538

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
 
R

Roger Govier

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"
 
Top