LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ayd Ayd is offline
external usenet poster
 
Posts: 1
Default How do I get drop down menu's to show different background colour

I am trying to create a drop down list of options using data Validation in
Excel 2003. I have set it up fine, but want the results to show the
background colour that I have selected for them.

For example, if option 1 is selected, the cell would turn green, option 2,
blue, etc.

Is this possible, and if so, how, as my list will currently only display the
text, and no colour?

Kind regards
 
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
What do the underlined letters in the drop down menu's mean? beagle501 Excel Discussion (Misc queries) 1 September 15th 08 03:44 PM
Drop Down menu's Lee Excel Discussion (Misc queries) 2 December 4th 07 04:35 PM
Font Size in Drop Down Menu's James D. Sheehan Excel Discussion (Misc queries) 0 August 23rd 07 09:42 PM
change a cell background colour to my own RGB colour requirements Stephen Doughty Excel Discussion (Misc queries) 4 June 16th 06 01:08 PM
Drop Down Menu's abfabrob Excel Discussion (Misc queries) 4 February 4th 05 02:19 PM


All times are GMT +1. The time now is 05:58 PM.

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"