highlighting cell

  • Thread starter Thread starter ganga
  • Start date Start date
G

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