To your question - your link emulates the cell contents, not the cell
attributes.

You could, when selecting A1, hold the CTRL key and select the
additional cells, then colour them all together, or, as was suggested,
select the required cells and use Format, Conditional Format then when
A1 shows a colour for a value D1 etc will follow suit.

hint, you could use condition =" " (equal single space) set to Red to
not display these cells when blank, but colour-up when you prompt with
a space in the cell not yet phoned in.

Hope this helps

--

bre Wrote:
The colors mean something to me. The cells are for teams in a league. If
a team called in their score, the cell will stay white. If they don't
call, I will make the cell red so I can easily see who didn't call in
score of their game.

So is there any way to see what color the original cell is and have it
carried over to the pasted link?


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