Formatting
Conditional formatting rules for Google Sheets that color the right cells: checkboxes, dates, duplicates, top values and custom formulas, all tested.
-
Cross Out a Row When a Checkbox Is Checked in Google Sheets
A to-do list in Google Sheets looks much better when finished tasks are crossed out. You don’t need a script: a conditional formatting rule can apply strikethrough to the whole…
-
Conditional Formatting Custom Formulas in Google Sheets: 13 Tested Examples
A custom formula rule colors a cell when a formula you write returns TRUE. It is the most flexible kind of conditional formatting in Google Sheets: it can look at…
-
How to Change Row Color When a Checkbox Is Checked in Google Sheets
To color a whole row when its checkbox is checked, use a conditional formatting rule with a custom formula that points at the checkbox column with a dollar sign before…