SOLVED

Conditional formatting

Occasional Visitor

Hi I'm trying to set up a training matrix that will automatically highlight a training certificate which is valid for 1year that is due to expire in 30 days.

The matrix shows the date the training was taken and I would like it to automatically highlight when it is due to expire.

Hope this makes sense

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@yojojo 

The conditional formatting should read:

=EDATE(A2,12)-30<TODAY()

dscheikey_0-1663524629296.png

See also my attached sample document.

@dscheikey 

Thank you so much this has been driving me mad for days