Hello,
I need help with conditional formatting. I have an excel worksheet where I track orders that have been placed and any information regarding these orders, e.g., date it was submitted [Column A], Estimated Ship Date (ESD) [F], Ship date [G], Tracking [H], Estimated Time of Arrival (ETA) [I], etc. To help me prompt with what I need to do next, as there are a lot of orders to keep track of, I would like these cells to change color as these dates approach/have past.
1) I would like the cell in the ESD column (F) to change color if it is 5 days past the date it was submitted (5 days past date in column A). Then I would like it to change back if the cell in the ESD column is no longer blank.
2) I would like the cell in the Ship Date column (G) to change color if today is after the date in the ESD column (F). Then I would like it to change back if the cell in the Ship Date column is no longer blank.
3) I would like the ETA column (I) to color scale - darker if the date in this column is closer to today's date and lighter the further it is from today's date. Then I would like it change back if the cell in this column is no longer blank.
Please help!
Thank you
Bookmarks