Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 160
Default In-Cell Drop down color

Almost there. How do I format the text in the In-Cell Dropdown? I want to
give each choice a colored background or text at least. Thots?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default In-Cell Drop down color

Not sure about the first part. If you are using data validation, I would go
to the same cell and use Conditional Format under the Format Menu and add a
different format for each Validation List Option.

This is assuming you did not write this with VB and just used MS Excel
features...

"Patrick" wrote:

Almost there. How do I format the text in the In-Cell Dropdown? I want to
give each choice a colored background or text at least. Thots?

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
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
How can I determine cell color? Naum Excel Discussion (Misc queries) 3 May 14th 06 08:26 PM
COMMAND BUTTONS and CELL COLOR hookfault Excel Discussion (Misc queries) 2 April 10th 06 11:43 PM
Refreshing drop down cell values... Dyce Excel Worksheet Functions 0 August 24th 05 10:49 PM
Change cell color dependin on date ... T. Denford Excel Worksheet Functions 4 April 13th 05 01:59 AM


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