Conditional Formatting with Dates

[talltom]

Hi,

I have a spreatsheet in Excel 2003. It is used to track Purchase Orders.

Column F is the Date the items are needed to arrive. I would like a
conditional Format that would change the cell with the arrival date to Red if
the Item is within 2 workdays of the date that is in the cell.

Example: If the date in the cell is 6 Mar, and today is 4 Mar, I would like
the cell to turn Red.

Any help would be appreciated.

 

[Bob Phillips]

Use a CF formula of

=TODAY()+2>=F2

This will show red after the arrival date, you may want an extra test to
cater for those that have arrived.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[talltom]

Bob,

Thank You. It works like a charm

Use a CF formula of

=TODAY()+2>=F2

This will show red after the arrival date, you may want an extra test to
cater for those that have arrived.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)