ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Validation Drop-Down list formatting (https://www.excelbanter.com/excel-discussion-misc-queries/177400-validation-drop-down-list-formatting.html)

ktoth04

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

covingj

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?


ktoth04

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?


Gord Dibben

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?



ktoth04

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?





All times are GMT +1. The time now is 09:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com