Conditional Formatting Based on Date Older Than 1 Year in Excel
Excel Conditional Formatting Dates Older Than Today But Not Blank. Change its type to 'use a. Add an extra rule that formats blank cells with no fill.
Edit the rule for less than today. Change its type to 'use a. Add an extra rule that formats blank cells with no fill.
Edit the rule for less than today. Change its type to 'use a. Edit the rule for less than today. Add an extra rule that formats blank cells with no fill.
