LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Lookup table color

I have a very complicated formula that says, add these two cells and if it is
less than zero to go to a lookup table and display the results in the the
table. my question is, how can make it higlight the cell or use the color of
a cell in the lookup table so i can easily tell that it is getting the data
from the lookup table and not the added cells?
 
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
Using Lookup Function based on Font Color jstec68 Excel Worksheet Functions 1 March 13th 08 08:40 PM
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM
Using color in lookup lugnut Excel Worksheet Functions 1 June 18th 05 07:02 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
lookup table Nathan Excel Worksheet Functions 4 May 12th 05 03:09 PM


All times are GMT +1. The time now is 10:55 PM.

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"