Hi,

Cell A1 has a dropdown list (from Data/Validation/list)
with dates except one option wich is Released. What I
want is that:

A1 stays red when nothing is in the cell
A1 becomes yellow when I choose a date from my list
A1 becomes green when I choose Released from my list.

Please help. Red works, yellow works even when I choose
Released...but I want it to be green when it's released.

Thanks.

Paul