Hi,
I have a list of employees who are required to resubmit an applicaiton for a room and board allowance every six months from their hire date. I am looking to have the cell with thier hire date turn red or alert me in some way when an employee is two weeks from their due date to resubmit, or 5 and a half months from their hire date/ last submission.
I have attempted to use the conditional formatting tool however the options are limited and I don't know which formula to use. Please help!
The data looks like this (attached)
Bookmarks