Yes, select all cells. In CF, use a formula (Change Condition 1 to Formula
Is), and lock the column in the formula, such as

=$A1TODAY()

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"CBD" wrote in message
...
Not sure if this is possible... I have applied conditional formatting to a
cell in a row of information, to fill with colour on input of a specific
answer from a drop down.

Can I make the whole row change to the same colour along with the cell on
input of the answer.... can't find out how.

Any help much appreciated.
thanks