Conditional formatting

[yojojo]

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 · Accepted solution]

@yojojo 

The conditional formatting should read:

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

See also my attached sample document.

[#3]

@dscheikey 

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