I would like to have a formula or multiple formulas that would help identify when multiple conditions match. I had thought that regular excel formulas could accomplish this, but I am open to basic programming if needed.
If the location/department matches AND that match happened within 14 days prior to that entry, then we would like a cell highlighted.
I have attached a file that I have highlighted manually, that shows what I would like to have happen automatically with formulas.
Bookmarks