I don't follow why you can't CF all cells in the row the same as your
checker cell. Otherwise describe more clearly what you've got and what
formats you want to change under what condition(s).

Regards,
Peter T

"DDawson" wrote in message
...
I have various rows which are colour coded and I have added several
columns
on to the end - One for a checker to initial and several others for
approvals, comments and date.

I want the checker Cell to change colour when initials are entered (e.g.
=B10) I want the remaining cells on the row to change colour when
approval
initails are entered. I can do this with conditional formatting. The
problem
is I have been using Easyfilter to filter the colours - but when I try to
copy formats it is picking up the hidden rows.

I have resorted to copying and pasting the formatting only, but this is
going to take days. Is there a way to conditional format the colour, to
match
the colour of another cell in the row?

Regards
Dylan Dawson
Scotland