So is there any way I can have a dropdown box with the options, "G/Y/R", and then once the user makes their selection, change the cell contents to be a circle, colored appropriately based on whether the user selected G, Y or R?
You can't do this with the standard Data Validation drop down and it can only be done using VBA code.
If you can use a VBA solution then perhaps the attached will be helpful.
In the attached workbook . . .
An active-X combobox was created using a ListFillRange in column-K.
The code targets column-A. If the activecell is in column-A, then the comboxbox is made visible and presents a choice of G/Y/R. Once the selection is made, the activecell is formatted to the wingding font using the applicable color.
Bookmarks