Automatic Highlighting and expiration of Cells

This is my first post here on the forums and I'm hoping a genius on here can help me figure it out. The question I have today is:

I have a large document control register and it is updated daily and posted to a cloud for many people to access. It is very time consuming to constantly jump in and out and highlight and unhighlight as many things as there are and keeping track of which items that need to be unhighlighted. The thing I'm trying to figure out is if there is a formula for this...If i change any cell in a row I want the row to highlight itself entirely, but after 24 hours I want the highlight to expire. Is there a formula or function I can use to make this happen? If you need a further explanation I can try and give it to you as best as I can. I'm not extremely fluent in excel but getting a function like this would help my productivity tremendously! Any help is appreciated!!

Cheers!

As an example, I would like to be able to insert a row between 18 and 19 and have the inserted row highlighted for 24 hours, then automatically shut off. OR, as another example, I would like to add information to row 22, column L, and have row 22 automatically highlight for 24 hours. (or until the date automatically changes) Capture.jpg

My Apologies,

Attached is a workbook!Copy of Test.xlsx