Forum Discussion
yojojo
Sep 18, 2022Copper Contributor
Conditional formatting
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
The conditional formatting should read:
=EDATE(A2,12)-30<TODAY()See also my attached sample document.
2 Replies
- dscheikeyBronze Contributor
The conditional formatting should read:
=EDATE(A2,12)-30<TODAY()See also my attached sample document.
- yojojo2300Copper Contributor
Thank you so much this has been driving me mad for days