How to set up automatic date and time input when changing data in a row in Google SpreadSheets?

Question

Google Sheets

It is necessary to make it so that for any changes in the "x" line, the date and time are recorded in the "y" cell (it is desirable that the color of the cell also change).

Answer 1

I will donate 1000r for the correct answer

Answer 2

Do you want to not only record the date and time in one specific task, but also the flexibility to use this solution in all necessary cases? Send me an email and I'll answer and help you decide.