Conditional Formatting with Dates
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.
|