Home |
Search |
Today's Posts |
#1
|
|||
|
|||
text color change in cell reference
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. |
#2
|
|||
|
|||
That requires VBA. Check the archives:
http://groups.google.com/advanced_gr...ugroup=*excel* here's one suggestion: http://groups-beta.google.com/group/...misc/browse_fr m/thread/ccbd9afeb33f0cdb/e991c1faf1f02314 In article , TomKat743 wrote: 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. |
#3
|
|||
|
|||
Thank you but the link did not work.
"TomKat743" wrote: 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. |
#4
|
|||
|
|||
The link will work if you rebuild it into one line:
http://groups-beta.google.com/group/...91c1faf1f02314 or http://tinyurl.com/9tsnb Tomkat743 wrote: Thank you but the link did not work. "TomKat743" wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
How to get a cell reference of by searchig a text string? | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |