Conditional formatting

  • Thread starter Thread starter DebbieV
  • Start date Start date
D

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?

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?
Click to expand...

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
 
Hi Debbie,

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


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
Click to expand...

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 (e-mail address removed):
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?
Click to expand...

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


Regards
Claus Busch
 
Back
Top