Hi All,
I am preparing a delivery tracking report which should reflect the delays whenever I refresh or update the report. To be more precise, here is my question.
I have a deadline (date/time) in a cell and the very next empty cell should get highlighted in a color if the deadline is about to exceed (24 hours based on system time) and should get highlighted in another color if the deadline expired (based on the system time). This will help me in identifying the stage where it is about to delayed or passed the date. Once the delivery is done I will update the actual delivered date in the empty cell.
if my query is not clear please let me now.
Can some one help me in solving this.
Thanks
Abdul
Bookmarks