Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Validation Drop-Down list formatting

Is it possible to format the data in a validation drop-down list in Excel 2003?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Validation Drop-Down list formatting

It depends on the level of formatting you are looking for. I was able to
select acell containing a dropdown for a list, and use the options under the
format menu to change text properties (strike-through, text color)

"ktoth04" wrote:

Is it possible to format the data in a validation drop-down list in Excel 2003?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Validation Drop-Down list formatting

Oops, my bad... I meant size-wise... The text on the spreadsheet is fine, but
the text in the drop-down is significantly smaller. I'd like to make the
drop down text larger without making the spreadsheet itself any larger....

"covingj" wrote:

It depends on the level of formatting you are looking for. I was able to
select acell containing a dropdown for a list, and use the options under the
format menu to change text properties (strike-through, text color)

"ktoth04" wrote:

Is it possible to format the data in a validation drop-down list in Excel 2003?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Validation Drop-Down list formatting

No.

See Debra's site for possible workarounds.

http://www.contextures.on.ca/tiptech.html

Scroll through the DV section.


Gord Dibben MS Excel MVP

On Thu, 21 Feb 2008 09:04:01 -0800, ktoth04
wrote:

Is it possible to format the data in a validation drop-down list in Excel 2003?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Validation Drop-Down list formatting

Thanks!

"Gord Dibben" wrote:

No.

See Debra's site for possible workarounds.

http://www.contextures.on.ca/tiptech.html

Scroll through the DV section.


Gord Dibben MS Excel MVP

On Thu, 21 Feb 2008 09:04:01 -0800, ktoth04
wrote:

Is it possible to format the data in a validation drop-down list in Excel 2003?





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
Drop Down List Validation mico Excel Discussion (Misc queries) 2 November 28th 07 05:53 PM
Drop Down List + Validation Satheesh Chandrasekaran Excel Discussion (Misc queries) 1 November 16th 07 08:49 PM
drop-down list validation won't allow a different worksheet justmetn Excel Worksheet Functions 4 September 15th 05 05:33 PM
validation list with drop down list of options?? luke013 Excel Worksheet Functions 1 August 31st 05 01:16 PM
Data Validation using List (But needs unique list in drop down lis Tan New Users to Excel 1 July 8th 05 03:32 PM


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