validation list color

N

nbarr

i was wondering if there was any way to keep the background color of a cell
when you make it a drop down list using data -> validation. thanks
 
G

Gord Dibben

You want to keep the original BG color of the cell with dropdown list
menu?............no problem...........DV won't clear that out.

You want to keep the original colors of the cells that form the list range?

Can't be done.

You want a different color for an item after being selected in the DV
dropdown?

Use Conditional Formatting on the dropdown cell.


Gord Dibben MS Excel MVP
 

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation List 1
drop down menu color 1
Size of drop down in validation list 2
Drop down list 2
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Data validation list using filtered range 3
Color cell validation? 4

Top