I am creating a monthly status report for project reporting. At the top of the report, we'll say cell A1, I want the user to have the ability to select via dropdown box whether the project is in green, yellow or red status.

Here's the tricky part - I want the color status to be represented by a colored circle (lowercase L in Wingdings font).

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?

Thanks!