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.

FormatCFFormula is: =$C$4=37500

The $ signs are crucial.

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


Gord Dibben MS Excel MVP

On Tue, 21 Jul 2009 12:49:01 -0700, ganga
wrote:

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