Mini Byte: Conditional Formatting in Google Sheets

Thursday, August 31st 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

Text

Number

Date

Current Workshop Schedule

This workshop does not have any other offerings scheduled.

Resources

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