Tech Tip: Conditional Formatting in Google Sheets

If you liked adding checkboxes to Sheets, you’ll love being able to color-code based on whether the box is checked or not!
Highlight a group of cells and choose Format >> Conditional Formatting, then choose from the options.

Conditional Formatting lets you change fonts, colors, and formatting based on what is in a cell.
(Heads-up: checked boxes have a value “True” while unchecked boxes are “False”.)

You can do this with more than just text boxes! You can color-code based on dates, numbers, and text as well! 


Happy Formatting (Conditionally)!

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.