Hello,

I am trying to do a binary Red or Green. I have a due date of say 8/1/2007
for a set of projects. As I enter the completion date in field $C$2, in the
format mm/dd/yyyy, I want to compare it to the due date of 8/1/2007. Before
the due date, I am Green. After the due date I am Red. I can't seem to
figure out if I have a set due date. I see examples for comparing todays
date but not just a entered date to a fixed date.

Thanks!!