LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
References to external XLS files goto_guy Excel Discussion (Misc queries) 1 January 17th 06 04:34 PM
How prevent formulas to get external references/path to current workbook? Gunnar Johansson Excel Worksheet Functions 1 August 15th 05 10:39 AM
External References in Excel Francist Setting up and Configuration of Excel 1 August 11th 05 12:38 AM
External References Iain Excel Discussion (Misc queries) 1 February 3rd 05 09:45 AM
External References not working right. Dread_Pirate_Roberts Excel Worksheet Functions 13 December 8th 04 11:07 PM


All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"