I want to change the color of a cell's background based on valid data in the cell. I have a pull-down list, it uses a named list, and this all works fine, thanks for your help earlier on that question.
I want the cell to be red, and then after the user selects a valid entry from the pull-down list, I want to change the cell to yellow.
EDIT: I found the conditional formatting, but how do I point it to the named list?
Bookmarks