I am trying to highlight particular rows in a RFI log based on a due date (orange for due date coming up, Red for due date passed with no response, but turning green for those where an answer was received, even if it is passed the due date. Scaled coloring would be nice, but not necessary. I have tried a number of things and scoured the internet, but I am stumped so far. Anybody able to help me out? I have attached a copy of the spreadsheet. Also, it cannot be based on a macro, as i want to use it in Microsoft Teams, and i recently discovered that Macros' apparently don't work in TEAMS.
Bookmarks