This should be simple, but. . .
Im tracking delivery of files. On-time or early is green, one to five days
late is yellow, more than five days late is red. In my example, the due date
is stored in cell B4, the actual date received is in cell C5.

I am using conditional formatting, €œUse formula to determine which cell to
format.€� On-time or early is easy, I just enter =($B$4 = $C5) to say if due
date is greater than or equal to received date, and set my fill color. Very
late is easy, I enter =(($B$4+5)<$C5 +5) to say if due date plus 5 is less
than received date.

The middle ground has me stumped. How do I say if received date is within a
range of the due date (due date plus 1 through due date plus 5, inclusive)?

=AND($C5$B$4,$C5<=($B$4+5))

I think I would change your 'very late' formula to this:
=$C5($B$4+5)

Hope this helps.
--
John C


"Meowzer" wrote:

This should be simple, but. . .
Im tracking delivery of files. On-time or early is green, one to five days
late is yellow, more than five days late is red. In my example, the due date
is stored in cell B4, the actual date received is in cell C5.

I am using conditional formatting, €œUse formula to determine which cell to
format.€� On-time or early is easy, I just enter =($B$4 = $C5) to say if due
date is greater than or equal to received date, and set my fill color. Very
late is easy, I enter =(($B$4+5)<$C5 +5) to say if due date plus 5 is less
than received date.

The middle ground has me stumped. How do I say if received date is within a
range of the due date (due date plus 1 through due date plus 5, inclusive)?

Thanks so much, this works like a charm.

"John C" wrote:

=AND($C5$B$4,$C5<=($B$4+5))

I think I would change your 'very late' formula to this:
=$C5($B$4+5)

Hope this helps.
--
John C


"Meowzer" wrote:

This should be simple, but. . .
Im tracking delivery of files. On-time or early is green, one to five days
late is yellow, more than five days late is red. In my example, the due date
is stored in cell B4, the actual date received is in cell C5.

I am using conditional formatting, €œUse formula to determine which cell to
format.€� On-time or early is easy, I just enter =($B$4 = $C5) to say if due
date is greater than or equal to received date, and set my fill color. Very
late is easy, I enter =(($B$4+5)<$C5 +5) to say if due date plus 5 is less
than received date.

The middle ground has me stumped. How do I say if received date is within a
range of the due date (due date plus 1 through due date plus 5, inclusive)?

Thanks for the feedback. And don't forget to check the YES box :)
--
John C


"Meowzer" wrote:

Thanks so much, this works like a charm.

"John C" wrote:

=AND($C5$B$4,$C5<=($B$4+5))

I think I would change your 'very late' formula to this:
=$C5($B$4+5)

Hope this helps.
--
John C


"Meowzer" wrote:

This should be simple, but. . .
Im tracking delivery of files. On-time or early is green, one to five days
late is yellow, more than five days late is red. In my example, the due date
is stored in cell B4, the actual date received is in cell C5.

I am using conditional formatting, €œUse formula to determine which cell to
format.€� On-time or early is easy, I just enter =($B$4 = $C5) to say if due
date is greater than or equal to received date, and set my fill color. Very
late is easy, I enter =(($B$4+5)<$C5 +5) to say if due date plus 5 is less
than received date.

The middle ground has me stumped. How do I say if received date is within a
range of the due date (due date plus 1 through due date plus 5, inclusive)?