View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike C Mike C is offline
external usenet poster
 
Posts: 25
Default 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