Conditional formatting

[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

 

[Claus Busch]

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

 

[Spencer101]

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

Thanks
Debbie

Hi Debbie,

Conditional formatting does not work across differen
worksheets/workbooks

 

[cavvie123]

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

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?

 

[Claus Busch]

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?

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


Regards
Claus Busch