Paperless Is Not a Pedagogy

Alice Keeler

CHECK the Conditional Formatting

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

Template

Make a copy of the template

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

Want More Help with This? Become a Premium Member

$12 per Month: Cancel Anytime

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

About Your Data PII

App’s use and transfer to any other app of information received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements.

Compliance with Google’s Limited Use Policy

AliceKeeler LLC is committed to complying with the Google API Services User Data Policy, including the Limited Use requirements. Our use and transfer of information received from Google APIs adhere strictly to these policies, ensuring data is used only for the purposes necessary to provide and improve the Service.

Limited Use of Google User Data: The Service only accesses and uses Google user data in ways that are essential for the functioning and improvement of the Service, and not for independent purposes.
Transparency and Consent: We provide clear notice and obtain explicit consent from users before accessing or using their Google user data.
Data Minimization: We access only the minimum amount of data necessary from Google APIs to provide our Service.
Security Measures: We implement robust security measures to protect the confidentiality, integrity, and availability of Google user data.
Third-Party Sharing Restrictions: We do not share Google user data with third parties unless it is strictly necessary for the functioning of the Service and compliant with the Google API Services User Data Policy.
Google API Services User Data Policy: For more information about how we comply with the Google API Services User Data Policy, including the Limited Use requirements, please visit Google API Services User Data Policy.

For any questions or concerns regarding our use of Google user data, please contact us at info@alicekeeler.com.

© 2025 All Rights Reserved.