Dear All,
I am creating a spreadsheet to monitor if I deliver on time the orders placed between me and my clients.
In a column I have added dates when each order has to be delivered.
Using the Conditional Formatting I have managed to set the cell to change color when the order is late (red) and 1 week before when it will be supposed to be sent (orange):
=TODAY()-A1>=0
=TODAY()-A1<7
I also would like to alert me 1 month before the delivery date but once I set the formula (with yellow color):
=TODAY()-A1<30
The cell doesn't change color and It stays orange.
I also would like the cell remain white when the delivery date is not due until one month before.
I hope I have been enough clear, my excel knowledge and my english are not that great!
Thank you
Bookmarks