How can I carry cell formatting in paste link

[bre]

I have a big worksheet with sub totals evry 50 or so lines. I pasted
links to the subtotals to the right of that so I can just see subtotals
at a glance without having to scroll down entire sheet. On the subtotals
on the left (with the details), I have color (conditional) formattin
where I change cell color to red if its negative.

Guess you can picture it now. I would like to have the conditional
color formatting carry over to the subtotal cells on the right that
where the links were pasted. Right now its just showing plain cells
even if the main cell is red (negative).

Hope this isn't too confusing. Thanks.

 

[bre]

Made a mistake explaining. The cells on the left do not have conditional
formatting, they are just colored red manaully if they are negative. I
stil want the cells on the left that the links were poasted to be in
color if the corresponding cell on the left is colored. In other words,
I want to paste the link AND the color of the original cell.

 

[Ragdyer]

How about using conditional formatting on the column that the link is
populating?

 

[bre]

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.

 

[Ragdyer]

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

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

 

[bre]

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]

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

--