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

You can do it with a formula such as =IF($A10,true,false) or
=IF($A$10,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

"ingalla" wrote in message
...
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

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"
--
David Biddulph

"ingalla" wrote in message
...
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