coloring cells based upon formula reference
Posted by George on February 20, 2001 11:54 AM
I have a workbook with 12 different sheets.
Some of the formulas reference cells on the same
sheet while other formulas reference cells on other
Is there a way to change the cell color to red if the
formula in that cell refers to another sheet?
in sheet 1, the formula in cell c1 is a1+b1. (this
cell color is okay)
in sheet 2, the formula in cell c1 is Sheet1!C1+a1+b1
(I want this cell to be red)