Formula... conditionnal format

[Paul]

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

 

[Tom Ogilvy]

format the cells to be yellow

then do format=>conditional formatting
for condition 1,
cell value is equal to ="Released"

format
Pattern Tab
choose green

for condition 2
Cell Value is equal to =""

Regards,
Tom Ogilvy