I need a formula to highlight a cell if it is "overdue", please.
I'm tracking employee training records that need to be updated annually. I have a column (S) with the date it was last updated, then the next column (T) I have a formula that is =S5+365, to give me the next due date.
What would the formula be to highlight the cell in column T, if it is past due?
I'm tracking employee training records that need to be updated annually. I have a column (S) with the date it was last updated, then the next column (T) I have a formula that is =S5+365, to give me the next due date.
What would the formula be to highlight the cell in column T, if it is past due?