Identify external references (in formulas) and color format
Hi,
I have a conditional format which allows me to identify/format all cells
that have formulas. In this instance it changes the font to Blue so that
every number that is blue, i know is a formula. I want to take it one step
further and maybe give the whole cell a color if the formula references an
external link, while all internal workbook links would just remain blue font,
the external references in formulas would cause the whole cell to be colored
(say orange). Any ideas?
--
Mike
|