I want to create a spreadsheet to track completion of physical examinations. The start of the examination process will have a start date and a expiration date. As an example, a beginning date will listed in A2 and an expiration of the process in F2. I need a visual cue to let my staff know that the uncompleted process is nearing the dealine of say...60 days. I want the whole row of entries to turn yellow at 30 days until deadline and red at 7 days until deadline. Can this be done with conditional formatting?
Bookmarks