How about changing the color of tick boxes in Google Sheets when they are toggled? Imagine having the ability to turn the tick box red when it’s checked. Sounds cool, right?
Well, if you’re curious about how to make this happen, you’ve come to the right place. In this article, we’ll explore different options to change the tick box color while toggling in Google Sheets.
The Highlighting Rule to Change the Tick Box Color While Toggling in Google Sheets
In this example, we’ll focus on changing the color of ticked tick boxes to red. Here’s how you can achieve this using conditional formatting:
-
Navigate to the very first cell in the range that contains the tick boxes (e.g., C2).
-
Access the conditional formatting menu by going to Format > Conditional formatting.
-
Configure the custom formatting based on the provided screenshot.
In the Conditional Format Rules panel, select the range where you want to apply the highlighting. In our example, it’s the range C2:C8. Then, choose « Is equal to » under « Format cells if… » and enter the Boolean value TRUE in the field below. Finally, select the desired text color and fill color. I recommend using red for the text color and white for the fill color.
Conditional Formatting Formula to Change the Row Color When the Tick Box is Ticked
If you want to highlight the entire row when the tick box is toggled, you can use a custom formula. Here’s how:
-
Select the range A2:C8 in the Conditional Format Rules panel, as we want to change the row color.
-
Set the custom formula to
=$C2=TRUEor=$C2:$C=TRUE, depending on your preference. -
Choose the desired text and fill colors.
By utilizing these conditional formatting techniques, you can easily change the tick box color or highlight rows in Google Sheets based on their tick box status. It’s a simple yet powerful way to make your sheets visually appealing.
The logic behind these formatting techniques revolves around the Boolean values of the tick boxes. By default, the value of a ticked box is TRUE, while an unticked box is FALSE. You can tap into this change in value to format the cells or rows containing the tick boxes.
If you’d like to learn more about inserting tick boxes in Google Sheets and modifying their default values, I recommend checking out my tutorial: Insert CheckBox, Tick Mark in Google Sheets.
Now that you know how to change the tick box color while toggling in Google Sheets, it’s time to unleash your creativity and make your sheets stunning. Enjoy the process and have fun exploring the possibilities!
