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

On Thu, 5 Feb 2009 14:33:36 -0800, nbarr
wrote:

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