Check the formatting google sheets

Color Code Your Google Sheets with a Checkbox

I like to joke that the greatest invention of my lifetime is checkboxes in Google Sheets. They are SO EASY! Use the Insert menu and choose checkbox. Boom! Now when you check that checkbox, you want something to happen. How about cells light up?!

Checking checkboxes to highlight a column in Google Sheets

Highlight Range of Cells

Insert some checkboxes into your Google Sheets spreadsheet and then highlight the cells you want to format when the checkbox is checked.

Format Menu

Go to the Format menu and choose “Conditional Formatting.”

Custom Formula

In the sidebar for conditional format rules change the format rules to “Custom formula is.”

Custom formula is


The custom formula starts with an equals sign. The statement to check for is A2 = true … assuming that A2 contains the checkbox. Notice this is a DOUBLE equals sign.


Choose the formatting for the custom formula =A2=true

Subscribe to the Alice Keeler Newsletter


WP Twitter Auto Publish Powered By :
%d bloggers like this: