Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Color of output

Is there a way to program Excel to display an output to an "IF" or "LOOKUP"
command in different colors for different answers? TIA


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default Color of output

You'd need to set some conditional formatting on the cell containing the formula.
Or use some event code to make the color adjustment.

Tim


"John" wrote in message ...
Is there a way to program Excel to display an output to an "IF" or "LOOKUP"
command in different colors for different answers? TIA




Reply
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
conditional formatting w/ color as input vs output tom Excel Worksheet Functions 3 December 13th 06 02:34 AM
Automatic color for output of a =sum action AndyE Charts and Charting in Excel 3 November 3rd 06 11:08 PM
How do you get a conditional output to show in color Luke Excel Discussion (Misc queries) 1 November 4th 05 11:06 PM
formula from multiple worksheets to give a color output to one wo. vikingshooter Excel Worksheet Functions 0 February 10th 05 03:19 PM
Output color to a text (rtf) file Wild Bill[_3_] Excel Programming 2 November 19th 04 11:05 PM


All times are GMT +1. The time now is 02:37 AM.

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

About Us

"It's about Microsoft Excel"