Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
References to external XLS files | Excel Discussion (Misc queries) | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
External References in Excel | Setting up and Configuration of Excel | |||
External References | Excel Discussion (Misc queries) | |||
External References not working right. | Excel Worksheet Functions |