Do you mean that you just choose a color out of the "blue"?<g

Seriously, is there no system to your choice of colors?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bre" wrote in message
...

No that won't work. There's no rhyme or reason to coloring the cell so
there's no way to format it. For instance, suppose I put and 'x' in A1,
'y' in A2 and 'z' in A3. Then I highlight the cells and copy then paste
link at D1. Now D1, D2 and D3 have the same thing as A1-A3 - 'x', 'y'
and 'z'. When I change anything in A1, A2 or A3, the changes show in
D1, D2 and D3. But if I change the color of A1 cell to say blue, D1
does not change. Somehow, I need D1, D2 or D3 cell color to change when
I change A1, A2 or A3 cell colors. Thanks.


--
bre
------------------------------------------------------------------------
bre's Profile:
http://www.excelforum.com/member.php...o&userid=20765
View this thread: http://www.excelforum.com/showthread...hreadid=535323