conditional formating

[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

 

[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"