Mini Byte: Making Sense of Google Sheet Data with Conditional Formatting

Tuesday, December 5th 11:00am - 11:30am
Online DoIT Training Adobe Connect Room

When working with data in spreadsheets, you can use automatic formatting rules (aka conditional formatting) to help make sense of data. Conditional formatting can automatically change font or background color, making spreadsheet data more easily understandable at a glance. 

*Must know the basics of Google Sheets and Google Drive.

Workshop Level: Intermediate

Audience: Clubs, Faculty, Researchers, Staff, Students and Teaching Assistants

What is Conditional Formatting?

With conditional formatting, data that meets a set requirement will display differently than data that doesn't.  Data can be crossed off, underlined, bolded, colored, highlighted, etc.. 

For example, you can set up conditional formatting so that guests who respond that they're not coming to an event are automatically crossed-off.

Conditional formatting allows for easy visual comprehension, a tool that is very helpful when dealing with large sets of data.

At The End Of This Workshop You Will Be Able To Automatically Format Cells Based On




Current Workshop Schedule

This workshop does not have any other offerings scheduled.


Browse presentation slides or view a previous session.

Additional Information

Related Content

Workshop Categories

Hosted By

For all other inquiries regarding this workshop please contact

DoIT Training and Development