Forum Discussion

yojojo's avatar
yojojo
Copper Contributor
Sep 18, 2022
Solved

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...
  • dscheikey's avatar
    Sep 18, 2022

    yojojo 

    The conditional formatting should read:

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

    See also my attached sample document.