View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
talltom talltom is offline
external usenet poster
 
Posts: 22
Default 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.