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