I have data validation set up for cells. The list I pick from, from the drop down, is called StatusCodes and contains:
Work
Vac
Trn
Sick
Lab
Class
Hol
Other
I simply want to color/fill each cell with a different color based on which selection from the dropdown I choose and at the same time keep the text chosen visible. Would I use Conditional formating or Smart Tags or what? Attached is a small example.
Bookmarks