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