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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted cell column in drop down list 1
Dependent drop down dynamic range formula, off sheet. 7
How to keep font color when referencing Sheets in the same workboo 4
excel 2003 drop-down box color changes how 2
Drop Down with dynamic named range offsheet source list 14
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Copy corresponding cell in Column B if cell in A contains certain text? 1
2 Different Font Colors in 1 Cell 15

Back
Top