How do I keep the color fonts in my cells when I use drop down?

T

tanks

I am working with two sheets in the same workbook. Sheet 1 is where I am
validating the cells named on sheet 2. The cells on sheet 2 have different
color fonts. When I validate them on sheet 1, I get the drop down list with
all the cells in the same black color. I want the drop down list to have the
same colors as they appear in the cells on sheet 2.
 
B

Biff

Hi!

Data validation drop down lists do not "bring" any formatting from the
source list.

About the only thing you could do is to apply conditional formatting to the
cell that contains the drop down. However, you can only have up to 3
different conditions.

Biff
 
Top