Hold down <Ctrl and click in the tab for Sheet2.
This "groups" the sheets, meaning whatever you do to one, will be duplicated
in the other.

When finished, don't forget to "ungroup" by right clicking in a tab and
choosing "ungroup sheets".
Forgetting to do this could create havoc in your WB!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"hobpedlar" wrote
in message ...

Hello,
I hope someone can help me.
This may well be a very basic question but I am totally new to Excel.
I want to know if I can have the color of a cell in sheet 1 change
automatically if I change the color in the corresponding cell in sheet
2...

Is this possible???

Waiting hopefully
Hobpedlar


--
hobpedlar
------------------------------------------------------------------------
hobpedlar's Profile:
http://www.excelforum.com/member.php...o&userid=25516
View this thread: http://www.excelforum.com/showthread...hreadid=389569