Excel Conditional Formatting a Date Question
 

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!!

Excel Conditional Formatting a Date Question
 

One way:

Format the cell as green (either font or background - you don't say
which)

CF1: Formula is =A1 DATE(2007,8,1)
Format: <font or pattern/Red


Note1: You don't say what should happen on the due date itself - if it
should be red, use = instead of

Note2: It doesn't matter what date format is displayed in the cell as
long as it's a date.

In article ,
Todd wrote:

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!!

Excel Conditional Formatting a Date Question
 

Thanks!! This did exactly what I needed. My problem was I entered the
DATE(mm,dd,yyyy) which would not work.

"JE McGimpsey" wrote:

One way:

Format the cell as green (either font or background - you don't say
which)

CF1: Formula is =A1 DATE(2007,8,1)
Format: <font or pattern/Red


Note1: You don't say what should happen on the due date itself - if it
should be red, use = instead of

Note2: It doesn't matter what date format is displayed in the cell as
long as it's a date.

In article ,
Todd wrote:

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!!