Hi Debbie,

Am Thu, 7 Jun 2012 00:19:17 -0700 (PDT) schrieb DebbieV:

Is there a way to have 2 worksheets with identical data on both and if there is a change on one of the sheets (lets call it 'master') that the row on the other sheet will change colour for that whole row or if easier just the corresponding cell?

in conditional formatting you can't refer to another sheet. The only way
is to give the range on master a name and use that name in the formula
for CF.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2