Conditional formatting

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
 
C

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?
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
 
S

Spencer101

'DebbieV[_3_ said:
;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
Click to expand...

Hi Debbie,

Conditional formatting does not work across differen
worksheets/workbooks
 
C

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
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?
 
C

Claus Busch

Hi,

Am Thu, 7 Jun 2012 05:09:46 -0700 (PDT) schrieb [email protected]:
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
 
Top