How to duplicate the date of filling a cell into the adjacent one and highlight it with color?

Question

Google Sheets

vertical list.
It is necessary that when filling in the cell, the date / time is automatically set in the next cell on the right.
And if there are no changes in the cell next to the left in 24 hours, highlight the middle cell with a color.
Example:

I enter the data in the "Last Name" (initially empty), the date / time is automatically set on the right.
Next comes the timing.
If the cell "Some link" is not filled/does not change within 24 hours from the moment of filling "Last name" - "Last name" is highlighted in color.

Answer 1

You need to write a script for this case :) I can help