Sep 18 2022 10:15 AM
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
Sep 18 2022 11:13 AM
SolutionThe conditional formatting should read:
=EDATE(A2,12)-30<TODAY()
See also my attached sample document.
Sep 18 2022 10:48 PM
Thank you so much this has been driving me mad for days
Sep 18 2022 11:13 AM
SolutionThe conditional formatting should read:
=EDATE(A2,12)-30<TODAY()
See also my attached sample document.