I'm creating a workbook to manage my leads as they come through with some details that'll then trigger to go to a working quote sheet. What I am looking to do is note the duplicate requests that we receive. The way I am hoping I can get it to work is below.
- Check column C and column E to see if both are duplicates
- If so, check column A to see if the date is exact
- If so, in column I type in "Duplicate Request"
- Check column C and column E to see if both are duplicates
- If so, check column A to see if the date is within 5 days
- If so, in column I change the fill of the cell to red