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