I would like to be able to have a data validation list where I can simply
choose a fill color. Is this possible. If not can do conditional formatting
so that if a cell says "Green" it will fill green but if it says "Yellow" or
"Red" it will fill the appropriate color. I tried the conditional formatting
but I could only figure out how to do one condition.

Failing both, is there a basic macro that I can use for this?

Any thoughts?

Thanks very much