Conditional formattion for whole row based on one cell value

[Madiya]

Hi,
I am using Excel 2007.
I need to use Conditional formating for whole row based on one cell
value.
If cell value is more then 25, cell colour formatting should be
applied to whole row.

Can some one pl explain me how to acheive it?

Thanks in anticipation.
Regards,
Madiya

 

[Mike H]

Hi,

Select your row and use this conditional format formula

=$A1>25

Pick a colour.

Mike

 

[Sheeloo]

It works because the $ before the column letter keeps the reference to column
A when Excel applies the formula to other cells in the row...

If you paint the same over second row it will refer to A2...

 

[Madiya]

It works because the $ before the column letter keeps the reference to column
A when Excel applies the formula to other cells in the row...

If you paint the same over second row it will refer to A2...






- Show quoted text -

Mike & Sheeloo,
Thanks. This works like charm.
Regards,
Madiya