New answers tagged


Use conditional formatting with custom formula =len(join("", B1:1)) The join concatenates all the values in that row, starting with B1. The formatting applies if the length of the concatenated string is not zero.


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.


The element shown in the screenshots is called Note. It could be added by using the Insert menu or a contextual menu. The user interface doesn't include a command to paste only the note but Class Range from the Google Apps Script Spreadsheet Service include several methods to handle notes: getNote() getNotes() setNote(note) setNotes(notes) The notes ...

Top 50 recent answers are included