Conditional Formatting comparing two dates
I'd like to create a conditioning formatting to highlight a cell based on the difference between two dates. Column A is the expected date of delivery. Let's say 1/1/23. Column B is the actual date I received it, say 1/5/23. I'd like it to follow this rule:
Highlight Column A cell when:
Received date is more than 5 days before expected date = green highlight
Received date between 5 days before and 5 days after expected date = yellow highlight
Received date is more than 5 days after expected date = red highlight
This was I can track if materials are being delivered in a timely manner.
Help Article Resources
Check out the Formula Handbook template!