I have a sheet of figures, numbers as values. I was wondering if there was a way to have a cell automatically change colors based upon either:

  1. Change colors based upon how long it has been since the cell was last updated.


  1. Changed based on the last comment made to that cell.

I just want the cells to change colors automatically based upon the age of the data.


Google Sheets cells doesn't include an age property, so you should decide how do you will record the cell last edition date, once you have decided maybe you could use the built-in conditional formatting tool. In either case you could use Google Apps Script to change the cell formatting.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.