conditional formating

I

ingalla

Hi

I can see how the conditional formating works in excel 2007 but how can i
fill the wole row with a colour when a certain cell contains the value that
want. I am managing to fill the cell with colour but not the row.

Any ideas to try.

Thanks
 
T

Tyro

You can do it with a formula such as =IF($A1>0,true,false) or
=IF($A$1>0,true,false) for cell A1 and in the Applies to: box, enter =$1:$1
You must make the address $A1 or $A$1, else this will not work.

Tyro
 
D

David Biddulph

In CF, instead of "Cell Value Is", use "Formula Is". To format the row
based on the value of column A, use =$A1="desired value"
 

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

Top