Data Validation Conditional Formatting....or both?

[Klee]

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

 

[Max]

.. but I could only figure out how to do one condition.

In the CF* dialog, click "Add >>" button to add conditions 2 and 3 ??
*xl2003

---

 

[Klee]

Thanks, it works great!

In the CF* dialog, click "Add >>" button to add conditions 2 and 3 ??
*xl2003

---

 

[Max]

welcome, glad that did it!