How to create Conditional Formatting on a TEXT cell if the status is not current
Hello all - I have a status update sheet in which I wanted to create a conditional format to HIGHLIGHT a cell if the Status Update (text) is BLANK and/or 7 days ago. The cell is a TEXT cell that includes the date + status details; I.e. "10/16 We are now live." What I wanted to do is highlight the cell if the status update was NOT current (within the past 7 days) - for example if the status update says "9/15 We are live" - this would let me know that the status update is OUT OF DATE and not current. I am not finding a way to add this conditional format to the cell since my cell property is TEXT and not a date. Does anyone have a work around?
Help Article Resources
Check out the Formula Handbook template!