Copying the formats is fine, but I was really hoping to link them, so if it
changed on the 1st worksheet it would reflect in the second. If a macro is
the way to go I may look into this, but the effort may surpase the need.

Thanks

"John James" wrote:


You can manually apply the colour, or copy the formats (edit-paste
special formats) which copies all formats including colour, or set up a
style with this colour and apply the style. There is no in-built
functionality to do what you've asked.

A macro which builds the formula and copies the colour in one process
is the alternative. Is this justified by your need?


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=533976