Conditional Formatting With Checkboxes in Google Sheets
Learn how to use checkboxes for conditional formatting in Google Sheets to visually manage your tasks. This tutorial covers setting up checkboxes, applying custom formatting, and enhancing your checklist functionality.
We have a checklist , and we want to format the text in this task column with a checkbox . We're going to do some conditional formatting with a checkbox . Checkbox is just a visual representation of true or false. When it's unchecked, it's false. When it's checked, it is true. This helps us with our conditional formatting . Let's select the B column, go up to Format, Conditional Formatting. We're going to change our format rules. To a custom formula here. We're going to say equals and we need dollar sign a1 This means we're in the B column But we're looking at the a column the dollar sign means we always want to look at the a column and we say equals True and what this means is that we're going to do this Formatting whenever the a column is true. So we want if none fill color.
Let's do a strikethrough first And hit done. And if we check off something, we have a nice little strikethrough , but let's say we want to do more. Let's go back and edit our custom formula . And instead of a strikethrough , we're going to color it all black. So we need the background to be black and the text to be black. And it only keeps the emoji shown. So every time. Oh, everything goes away, but what if we wanted it across the entire range , or the entire row ? Well, we need to change our range to A colon B, and now when we check off, even the checkbox disappears. But it's actually all there. We can select them and hit the space bar and uncheck them all at the same time, or check them at the same time. If you're looking for more cool Conditional formatting, automations, getting more out of your Google Sheets, subscribe here to BetterSheets on YouTube.