Custom Conditional Formatting Argument: cell reference - cell reference minus 180 days

Occasional Contributor

Here are the following factors:


Narrative Scenario:  Applicants are required to submit appraisals with their applications; appraisals cannot be older than 180 days from the submittal date. Applicants who submit appraisals beyond the 180 day threshold will be disqualified.


1 Applicant 1Applicant 2
2Application Date8/1/20217/1/2021
3Appraisal Date3/1/202111/1/2020


what's the proper syntax for conditional formatting argument to highlight cells that would indicate disqualification?


2 Replies
best response confirmed by domdel (Occasional Contributor)


Hello, how are you doing?


Find attachment

Thank you. This worked. The problem I had was Excel was adding quotes to the formula. Once removed, it worked.