| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
validation list color
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
validation list color
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change color of Drop Down List (Validation box) | Setting up and Configuration of Excel | |||
| how do i give differect color for validation list? | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| in a data validation list how do i color a choice? | Excel Discussion (Misc queries) | |||
Linear Mode
