Data Validation Conditional Formatting....or both?
 

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

Data Validation Conditional Formatting....or both?
 

.. 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Data Validation Conditional Formatting....or both?
 

Thanks, it works great!

"Max" wrote:

.. 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Data Validation Conditional Formatting....or both?
 

welcome, glad that did it!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Klee" wrote in message
...
Thanks, it works great!