ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/101657-excel-2000-a.html)

Cardinalgal

Excel 2000
 
I have a large spreadsheet of information where almost all of the cells are
linked (eg. =A13) to referenced cells at the top of the page, so if one item
changes at the top then everything linked to that cell changes. I am looking
for a way to make the linked cells change color if I change the referenced
cell's color. Any help would be greatly appreciated. Thanks...

Dave Peterson

Excel 2000
 
Formulas don't return this kind of formatting.

Maybe copying and pasting would work for you?

Cardinalgal wrote:

I have a large spreadsheet of information where almost all of the cells are
linked (eg. =A13) to referenced cells at the top of the page, so if one item
changes at the top then everything linked to that cell changes. I am looking
for a way to make the linked cells change color if I change the referenced
cell's color. Any help would be greatly appreciated. Thanks...


--

Dave Peterson


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com