Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Here is my problem, I have a list of dates of when a product was shipped in column C and the date when it was received in column D. I would like the date in D to be highlighted red when it is more than 3 working days from the date in C and green when it's less than or equal to 3 working days. I would also like the rest of the cells in D to be white until a date is entered. Any help and advice that you can offer would be appreciated. Thanks, Gav. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Please help with Conditional Formatting | Excel Discussion (Misc queries) |