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 w...
- Sep 18, 2022
The conditional formatting should read:
=EDATE(A2,12)-30<TODAY()See also my attached sample document.
dscheikey
Sep 18, 2022Bronze Contributor
The conditional formatting should read:
=EDATE(A2,12)-30<TODAY()See also my attached sample document.
yojojo2300
Sep 18, 2022Copper Contributor
Thank you so much this has been driving me mad for days