Conditional Formatting Formula

[spr1nger]

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?

 

[Joe4]

So, do you mean to check if the date in column T has passed?

If so, then try:

=$T2<TODAY()

 

[spr1nger]

Yes that is what I was looking for. Thank you!

 

[Joe4]

You are welcome.
Glad I was able to help!