Very difficult, as a colour change does not trigger any event.

You could create toolbar button that sets the colour and then auto-updates
the linked cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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