validation list color

  • Thread starter Thread starter nbarr
  • Start date Start date
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
 
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
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
drop down menu color 1
Color cell validation? 4
Data Validation List (Drop Down) Not Showing 2
Drop down list 2
Size of drop down in validation list 2

Back
Top