Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting - Dates | Excel Discussion (Misc queries) | |||
Conditional Formatting for dates | Excel Worksheet Functions | |||
Help with Conditional Formatting (Dates) | Excel Discussion (Misc queries) | |||
conditional formatting dates | Excel Discussion (Misc queries) | |||
Help with Conditional formatting with Dates | Excel Discussion (Misc queries) |