Then we check the result with a logical expression.
When an expression returns TRUE, the conditional formatting is triggered.
Rule 1 tests if the variance is less than 3 days.
Rule 2 checks if the variance is less than 10 days.
Rule 3 checks if the variance is greater than or equal to 10 days.
Both rule 1 and rule 2 have “stop if true” enabled.
When either rule returns TRUE, Excel will stop checking additional rules.
For more information on building formula criteria, see50+ formula criteria examples.
The TODAY function takes no arguments.
it’s possible for you to format the value returned by TODAY with a datenumber format.
