Conditional formattion for whole row based on one cell value

M

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
 
M

Mike H

Hi,

Select your row and use this conditional format formula

=$A1>25

Pick a colour.

Mike
 
S

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...
 
M

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 -
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you conditionally format a whole row based on data in one cel 1
Conditional formatting 3
conditional formating for the whole row, based on one cell value 2
Excel VBA 1
conditional format whole row based on 2 rows 1
Format a whole row based on value of one cell 2
Conditional Formating based on Data Validation 3
Conditional formatting to color rowsbased on cell value 1

Top