text color change in cell reference

[Guest]

I have a workbook in excel 2003 with two sheets. Cell references on the
second sheet refer to the first sheet ='CODE SHEET'!I102 when I change text
color in cell I102 on the code sheet how do I get the color to automatically
change on the second sheet.

 

[JE McGimpsey]

That requires VBA. Check the archives:

http://groups.google.com/advanced_group_search?as_ugroup=*excel*

here's one suggestion:

http://groups-beta.google.com/group/microsoft.public.excel.misc/browse_fr
m/thread/ccbd9afeb33f0cdb/e991c1faf1f02314

 

[Guest]

Thank you but the link did not work.

 

[Dave Peterson]

The link will work if you rebuild it into one line:

http://groups-beta.google.com/group..._frm/thread/ccbd9afeb33f0cdb/e991c1faf1f02314

or

http://tinyurl.com/9tsnb