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?

Thanks
Debbie

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

Hi Debbie,

Conditional formatting does not work across different worksheets/workbooks.

On Thursday, June 7, 2012 6:26:45 PM UTC+10, Claus Busch wrote:
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

Thanks Claus but excuse my ignorance - should it be cell based or lookup function etc. Do you have a whizz bang formula that would apply the conditional formatting if a cell in the row is changed in the master?

Hi,

Am Thu, 7 Jun 2012 05:09:46 -0700 (PDT) schrieb :

Thanks Claus but excuse my ignorance - should it be cell based or lookup function etc. Do you have a whizz bang formula that would apply the conditional formatting if a cell in the row is changed in the master?

Do it with VBA
Use the Worksheet_Change event from sheet Master to color the cell in
sheet2


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