Conditional formattion for whole row based on one cell value
On May 30, 9:16*pm, Sheeloo wrote:
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...
"Mike H" wrote:
Hi,
Select your row and use this conditional format formula
=$A125
Pick a colour.
Mike
"Madiya" wrote:
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- Hide quoted text -
- Show quoted text -
Mike & Sheeloo,
Thanks. This works like charm.
Regards,
Madiya
|