Change the Checkbox Color While Toggling in Google Sheets

Written by Abid Akon

Here's what we'll cover:

When the Checkbox feature was added to Google sheets in 2018, it was mainly used to tick out information from to-do lists, schedules and timetables. 

It was discovered recently that checkboxes can also work in conjunction with conditional formatting in Google Sheets.

The conditional formatting applies color, conditions and formulas to the worksheet, making dissemination and evaluation of data easy. 

In this tutorial, we are going to learn how to change the color of checkboxes when they are toggled.

How to Change the Checkbox color while Toggling in Google Sheets.

  This is done in two ways.

  1. Conditional formatting formula to change checkbox colors.
  2. Conditional formatting to highlight the row ticked.

Method 1: Conditional formatting formula to change checkbox colors

This is a method that only changes the color of the checkbox without highlighting the whole row. In the sample worksheet below, we have a daily routine and the schedule of each chore.

1 Change the Checkbox color while Toggling in Google Sheets

We are going to insert checkboxes into the worksheet and add color to them so that when a routine is completed it gets highlighted in the selected color.

Step 1: Select a cell or range of cells where the checkboxes would be inserted.

2 Change the Checkbox color while Toggling in Google Sheets

Step 2: Select Insert on the toolbar.

3 Change the Checkbox color while Toggling in Google Sheets

Step 3: From the drop-down menu displayed, select Checkbox.

4 Change the Checkbox color while Toggling in Google Sheets

Step 4: The checkboxes are inserted into the selected cells. The checkboxes can be ticked on or off the worksheet.

5 Change the Checkbox color while Toggling in Google Sheets

Now, we want to change the color of the checkboxes.

Step 5: Click on Format on the toolbar.

6 Change the Checkbox color while Toggling in Google Sheets

Step 6:  From the menu, select Conditional Formatting.

7 Change the Checkbox color while Toggling in Google Sheets

Step 7: The conditional formatting tab is opened on the right side of the worksheet.

8 Change the Checkbox color while Toggling in Google Sheets

Step 8: Input the range of the checkboxes in the worksheet, that is A2:A17.

Step 9: Under Format rules, select Is equal to.

9 Change the Checkbox color while Toggling in Google Sheets

Step 10: Enter the condition as TRUE. This means that when the box is checked, it is true it becomes colored while if it gets unchecked, it is false and the color is removed.

10 Change the Checkbox color while Toggling in Google Sheets

Step 11: Click on the fill color icon here and select any color of your choice.

11 Change the Checkbox color while Toggling in Google Sheets

Step 12: Click Done.

12 Change the Checkbox color while Toggling in Google Sheets

If a checkbox is selected, it becomes colored and if it’s unchecked, the color is removed.

13 Change the Checkbox color while Toggling in Google Sheets

Method 2: Conditional formatting to highlight the row ticked.

This is the second method used to color checkboxes, but the entire row is also highlighted when the checkbox is checked.

Step 1: Click on Format on the toolbar.

14 Change the Checkbox color while Toggling in Google Sheets

Step 2:  From the menu, select Conditional Formatting.

15 Change the Checkbox color while Toggling in Google Sheets

Step 3: The conditional formatting tab is opened on the right side of the worksheet. Input the entire range of the worksheet.

16 Change the Checkbox color while Toggling in Google Sheets

Step 4: Click on the drop-down arrow to Format rules, and select the Custom Formula Is.

17 Change the Checkbox color while Toggling in Google Sheets

Step 5: Input the formula as =$A2=TRUE

18 Change the Checkbox color while Toggling in Google Sheets

Step 6: Under formatting style, click on the fill color icon and select any color. You can also add extra formats like Bold, Italics or Strikethroughs so that when the checkbox is ticked, the respective texts are also highlighted and formatted to the selected style.

19 Change the Checkbox color while Toggling in Google Sheets
21 Change the Checkbox color while Toggling in Google Sheets

The Logic behind the Checkbox color Changes.

The reason for the color changes in the checkbox is that an unchecked box is FALSE by default. When checked, the value changes to TRUE. 

It is an important factor that aids the color formatting of the checkbox. To prove this, select a cell with a single checkbox and input the formula =A1 into another empty cell.

22 Change the Checkbox color while Toggling in Google Sheets

This would return the default values of the cell to TRUE and if it becomes unchecked, it changes to FALSE.

23 Change the Checkbox color while Toggling in Google Sheets
24 Change the Checkbox color while Toggling in Google Sheets

Note that the default values of the checkbox can also be changed through Data validation.

Click on Data, then Data validation.

25 Change the Checkbox color while Toggling in Google Sheets
26 Change the Checkbox color while Toggling in Google Sheets

Click on the cell range textbox and select the cell or range of cells with the checkboxes.

Under the criteria tab, select the Checkbox.

27 Change the Checkbox color while Toggling in Google Sheets

Click on Use Custom cell values. The two default values are TRUE and FALSE. Let’s change it to 1 and 0.

28 Change the Checkbox color while Toggling in Google Sheets
29 Change the Checkbox color while Toggling in Google Sheets

Click Save.

30 Change the Checkbox color while Toggling in Google Sheets

By typing the formula =A2 into an empty cell. When checked, the returned value is 1 while when unchecked, the returned value is 0.

31 Change the Checkbox color while Toggling in Google Sheets
32 Change the Checkbox color while Toggling in Google Sheets

Final Thoughts

Now, you know how to Change the Checkbox Color While Toggling in Google Sheets in 2022 using two different methods.

Checkboxes are very efficient features especially when applied with conditional formatting. I hope you found this article helpful. Thanks for reading.

Abid Akon

Abid Akon

I am a tech content writer. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I am writing articles to share my tech knowledge with you.

Related Articles

MD Abid Akon

Abid Akon

Hi, I am Abid. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I’ve created this website to share my technology keeping knowledge with you. Welcome to ”abidakon.com”

Abid Akon

My Personal Favorites
YouTube Channel