Are you wondering how to change the color of tick boxes in Google Sheets? Have you ever wanted the tick boxes to turn red when they are checked? If so, then keep reading! In this article, I will show you how to change the color of tick boxes in Google Sheets using conditional formatting. And the best part? You don’t need any programming knowledge!
Two Options to Change the Color of Tick Boxes
There are two different options that you can use to change the color of tick boxes in Google Sheets. Let’s take a look at each of them.
Option 1: Highlighting Rule
With the highlighting rule, you can make the checked tick boxes appear in red. Follow the steps below to achieve this effect:
- Select the first cell of the range containing the tick boxes (e.g., C2).
- Go to the “Format” menu and choose “Conditional formatting.”
- Set up the custom formatting based on the screenshot provided.
In summary:
- In the “Conditional formatting rules” pane, “Apply to range” is the range on which you want to apply the highlighting. In this example, it is the range C2:C8.
- Choose “Is equal to” under “Format cells if…” and enter the Boolean value TRUE in the field below.
- Select your preferred text color and fill color.
Option 2: Conditional Formatting Formula
If you want to highlight the entire row when a tick box is checked, you can use a custom formula in Google Sheets. In the previous example, the “Apply to range” was C2:C8. However, in this case, we will select A2:C8 because we want to change the color of the entire row.
Formula: =$C2=TRUE or =$C2:$C=TRUE
In the “Conditional formatting rules” pane, under “Format cells if…”, select “Custom formula is” and enter one of the formulas mentioned above. Choose your preferred text color and fill color.
The Logic Behind the Color Changes
The logic behind these two types of conditional formatting is simple. By default, the value of the cell containing the tick box is FALSE. When it is checked, the value changes to TRUE. This change in value can be used to format the cells or rows containing the tick box.
Sometimes, the value of the tick box is not necessarily TRUE or FALSE because Google Sheets allows you to change the default value. You can check whether the value of the tick box is TRUE or FALSE using the following method:
Suppose your cell C2 contains a tick box. In another empty cell, apply the following formula: =C2. This will return the value of the tick box.
If you want to learn more about how to insert a tick box in Google Sheets and change the default TRUE or FALSE value, you can follow my tutorial here.
I hope you now understand how to change the color of tick boxes in Google Sheets. Make your sheet visually appealing and enjoy the process!
Remember to visit Crawlan.com for more helpful articles and tutorials!
