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