00:00You can dynamically modify the cell color and the checkbox color when the checkbox is checked in Google Sheet.
00:06And this is how you do it. First, select only the checkbox in your data set here.
00:10And then after that, you go to Format, Conditional Formatting.
00:15And in here, as a rule, you're going to say is equal to.
00:19And the color that we'll be changing will be for checkbox, which is not checked.
00:23That's why you're going to have to write vault here. As you can see, it's starting to take shapes here.
00:28And next thing we're going to select is the fill color. We're going to select yellow.
00:32And the checkbox color itself, we're going to select font color and assign it as red.
00:39And click done. And I'm going to close this Conditional Formatting Rule menu here.
00:44So now every time you put a check on your empty checkbox like this, it will turn gray and white.
00:50And likewise, if you uncheck the checkbox, it will become yellow and red.
Comments