ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Validation (https://www.excelbanter.com/excel-discussion-misc-queries/14310-data-validation.html)

DLM

Data Validation

When I create my data validation list I have the cells in colored font. When
I select a cell with the data validation list they default to standard font.
Is there anyway to retain the formatting of the data validation list in the
drop down?
--
DLM

Debra Dalgleish

No, you can't format the items in a data validation dropdown list.

DLM wrote:
When I create my data validation list I have the cells in colored font. When
I select a cell with the data validation list they default to standard font.
Is there anyway to retain the formatting of the data validation list in the
drop down?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Myrna Larson

Sorry, no. What you see is what you get.

On Mon, 21 Feb 2005 18:21:01 -0800, DLM wrote:

When I create my data validation list I have the cells in colored font. When
I select a cell with the data validation list they default to standard font.
Is there anyway to retain the formatting of the data validation list in the
drop down?

All times are GMT +1. The time now is 04:31 PM.