Use Data Validation for the list. Type in Red, Yellow, Green as the list.

This give the user the list to select from.

Use Conditional Formatting for the fill part. Set three conditions, If Cell
Value-"Green" (select a green fill), etc..
--
If this helps, please remember to click yes.


"CassieB" wrote:

I am trying to allow someone to select "Green", "Yellow" or "Red" from a list
and the cell to display a green/yellow/red icon appropriately. Or, if
possible, the user could just select the icon (instead of selecting text).
Is this possible?