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)


The conditional formatting should read:



See also my attached sample document.


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