Hi people! I could use some help on a conditional formatting formula. I want to highlight a "status" cell if 2 conditions are met. One condition being the date in another column, the other condition being text that is showing in the column to be highlighted:
Column Q is the "status" column that shows either "inbound" or "complete"
Column P shows the date this item was shipped.
My goal is to have cell in Column Q highlighted in RED if the date in Column P is more than 4 days ago from todays date AND if the cell in Column Q does not say "complete"
The range of rows for these cells are 2-201.
Basically I am looking to be alerted when an item I am having shipped hasn't been delivered within 4 days of the shipping date. Thank you for you help in advance!
Bookmarks