I have a shared sheet called "Daily Status", people update their respective rows daily, I want to highlight row if it is not updated today.
For example below sheet, 2 out of 3 people updated their row, but John did not updated his status for the day, I want to highlight his row.
+──────────────+───────+────────────────+
| Description | User | Status |
+──────────────+───────+────────────────+
| Task 1 | James | 20% Completed | → Updated today
| Task 2 | John | 10% Completed | → Updated yesterday
| Task 3 | Jane | 100% Completed | → Updated today
+──────────────+───────+────────────────+
Important - When I open the same sheet tomorrow, all the rows should be highlighted, because the data was updated on the previous day, and when again someone fills in new data highlight should get removed.
Currently, I right-click on the particular row and click Show Changes to view when was it updated.
I don't think it is possible with conditional formatting or formula, I may need a script for this.
