highlighting cell

[ganga]

Hi all,

I want to highlight the whole row if one cell value is >= to 37500 using
conditional format.

eg.
if c4 is 43000, highlight (any color) row c.

Thank you in advance

 

[Gord Dibben]

Select the entire row..............row 4 in your case.

Format>CF>Formula is: =$C$4>=37500

The $ signs are crucial.

BTW...........C is not a row..........it is a column.


Gord Dibben MS Excel MVP