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
------------------------------------------------------------------------
bre's Profile: http://www.excelforum.com/member.php...o&userid=20765
View this thread: http://www.excelforum.com/showthread...hreadid=535323