# CHECK the Conditional Formatting

### 5 Myths About DOK (Critical Thinking)

CHECK the Conditional Formatting

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?!

## 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.

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.”

## =A2=true

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.

=A2=TRUE

## 10 thoughts on “CHECK the Conditional Formatting”

1. Stuart Gray says:

Love it! A great template to quickly utilize the power of conditional formatting. I introduced a number of our teachers to conditional formatting to highlight missing assignments and to colour code mark ranges in their gradebooks. A big help in quickly sorting through large numbers of marks.

2. Hyrum Balzer says:

I love this! I am creating a doc with 3 columns of checkboxes. I want when I click the box in column C it Changes the checkbox in column D to red. How can I format it so that when I check column D the red disappears? Thank you in advance!

1. Alice Keeler says:

This is possible I just do not have a quick answer on this for you. Good luck!

3. Donnie says:

I can’t get this to work for a range of cells, only a single cell. My checkbox is in A2, my range is B2:EV2. However, when the box is checked, only B2 highlights.

1. Alice Keeler says:

Try using Dollar Signs for absolute cell referencing.

1. Donnie says:

Dollar signs does get me the whole row/range, but there appears to be no way to “fill down”. Does each row need to be done individually?

1. Alice Keeler says:

It automatically figures it out based on the first one you set if you have it all highlighted when you create the rule

2. Dani says:

Did you work out how to get more than 1 cell to highlight?

3. Stacia says:

I was having the same issue and Alice’s tip solved the problem for me. Change the formula to this: =\$A2=true

This site uses Akismet to reduce spam. Learn how your comment data is processed.