Hi all, is it possible to change the colour of the font in a row depending on
one of the cell values in that row?
I can obviously use conditional formatting to change the font in the
particular cell that holds the data i will use, but i would like the entire
row to be formatted.

Basically i want the row to change to a light grey font when a particular
cell within that row says complete.

Is this at all possible?

any help appreciated.

Regards