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