Change the Tick Box Color While Toggling in Google Sheets

How about making your Google Sheets tick boxes more visually appealing? Have you ever wondered if there’s a way to change the color of the tick box when it’s checked? Well, you’re in luck! In this article, I will show you how to easily change the tick box color while toggling in Google Sheets, without any coding knowledge required.

Example 1: The Highlighting Rule to Change the Tick Box Color While Toggling in Google Sheets

Let’s start with an example where the color of the ticked tick boxes is red. Take a look at the image below:

To achieve this effect, follow these simple steps:

1. Navigate to the cell containing the tick box.
2. Access the conditional formatting menu by going to Format > Conditional formatting.
3. Configure the custom formatting based on the provided screenshot.
   • In the Conditional Format Rules panel, select “Apply to range” and specify the range where you want to apply the highlighting. For example, if your tick boxes are in the range C2:C8, enter that range.
   • 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. In this example, we chose red for the text color and white for the fill color.

And that’s it! Your tick boxes will now turn red when they are checked.

Example 2: Conditional Formatting Formula to Change the Row Color When the Tick Box is Ticked

Now, let’s explore another option where the entire row is highlighted when the tick box within that row is toggled. Take a look at the image below for reference:

To achieve this effect, follow these steps:

1. Navigate to the cell containing the tick box.
2. Access the conditional formatting menu by going to Format > Conditional formatting.
3. Specify the range of cells you want to apply the formatting to. In this example, select the range A2:C8 since we want to highlight the entire row.
4. Use the custom formula $C2=TRUE or $C2:$C=TRUE under “Format cells if…” to check if the tick box is checked in column C.
5. Select your preferred text and fill colors.

With this formula, whenever the tick box in column C of a row is checked, the entire row will be highlighted.

The logic behind these conditional formatting examples is simple. When a tick box is checked, its value changes from FALSE to TRUE. By utilizing this change in value, we can easily format the tick boxes or the cells/rows containing them.

Now that you know how to change the tick box color while toggling in Google Sheets, you can make your sheets more visually appealing and organized. Enjoy exploring the possibilities of customizing your Google Sheets!

To learn more about inserting tick boxes in Google Sheets and changing the default Boolean TRUE or FALSE value, check out my tutorial on how to insert check marks or tick boxes in Google Sheets.

I hope you found this article helpful in enhancing your Google Sheets experience. Feel free to reach out if you have any further questions!