Hello Everyone,
I am trying to figure out some formatting for my review tracker. See below for details....
Column B = Hire Date
Column C = 45 Day Review Date
Column D = Date the Review took place
I would like column C to be 45 days past the hire date, column B, and to highlight if it is later than the current date. With that, I want it to NOT be highlighted if there is date in column D.
Hope this isn't confusing.
Thanks !Review Tracker.xlsx
Maybe like this.
See the green cells in the attached file.
You could filter on column E to "To late".
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Maybe something like this might work. There is a a warning via Conditional Formatting that a review is coming within 7 days and on the date due the date turns red.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks