LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
jretherford
 
Posts: n/a
Default How do you get traffic lighting to work in Excel 2003

I am trying to assign a color code to a set of number 1=Green, 2=Yellow,
3=Orange and 4=Red. When the number 4 shows up in the cell, I want the cell
to turn red or Green if a 1 is entered. How can this be accomplished?
 
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
Link pictures in Excel 2003 doesn't work! ODI Excel Discussion (Misc queries) 4 November 5th 05 02:23 PM
How copy Excel macros from Excel XP (or before) to Excel 2003? ixoye Excel Worksheet Functions 3 November 3rd 05 08:28 PM
Excel 2000 to 2003 update links doesn't work properly any suggest Richard Excel Worksheet Functions 2 September 8th 05 01:06 AM
How do I open a Quattro Pro 7.0 file in Excel 2003 cpatrick83 Excel Discussion (Misc queries) 0 August 22nd 05 09:41 PM
trying to open an excel file in excel 2003 Edward Letendre Excel Discussion (Misc queries) 1 June 3rd 05 02:22 PM


All times are GMT +1. The time now is 03:32 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"