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

Question

Here are the following factors:&nbsp;Narrative Scenario:&nbsp; 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.&nbsp;&nbsp;ABC1&nbsp;Applicant 1Applicant 22Application Date8/1/20217/1/20213Appraisal Date3/1/202111/1/2020&nbsp;what's the proper syntax for conditional formatting argument to highlight cells that would indicate disqualification?&nbsp;

juliano-petrukio · Accepted Answer

domdel&nbsp;Hello, how are you doing?=(B2-B3)&gt;180Find attachment

Forum Discussion

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

2 Replies

Resources

	A	B	C
1		Applicant 1	Applicant 2
2	Application Date	8/1/2021	7/1/2021
3	Appraisal Date	3/1/2021	11/1/2020