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($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

"ingalla" <(E-Mail Removed)> wrote in message
news:275DC506-B5B1-4CC1-AE0D-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:275DC506-B5B1-4CC1-AE0D-(E-Mail Removed)...
> 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