 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2005Color Coding in a Drop Down List
Is there an easy way in MS Excel 2003 to color code the values in a drop down list. Actually not so much in the list itself, but once the value is selected and displayed in the cell. As an example, the drop down list contains "Passed", "Failed", and "Incomplete". Once the selection is made, I would like the background color of the box to be green, read, and yellow respectively. Thanks! Don Look at conditional formatting under format cell value is equal to Passed, then click format and pattern and select colour, click OK now select add and cell value equal to and so on, you can use 3 formats  SignatureRegards, Peo Sjoblom > Is there an easy way in MS Excel 2003 to color code the values in a drop > down list. Actually not so much in the list itself, but once the value is [quoted text clipped - 6 lines] > > Don Don't know how I missed that one, but I did! Works perfectly! Thanks! Don > Look at conditional formatting under format > cell value is equal to Passed, then click format and pattern and select [quoted text clipped - 12 lines] > > > > Don |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.