In our first tutorial on Google Sheets, we looked at extending the software's default conditional formatting options through the use of formulas. That solution is good for a limited range of dates, ...

Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and manipulate the data accordingly. Some knowledge of programming concepts ...