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.