Google Sheets - Checklist @lets.excel.it

Описание: 1. Highlight columns
2. Insert - Checkbox
3. Press cell at the top of the column to the right of the checkboxes
4. Format - Conditional Formatting
5. New Rule
Apply to range: the cell you have pressed
Format rules - Custom formula is: =D3=TRUE
D3 is the checkbox you want the applied cell
to react to
Style to preference
6. Repeat for the second column of checkboxes, applying to the same cell
7. Apply to more cells by editing the rules and applying to more