Google Sheets: Working with Data – Formatting your spreadsheet

[accessally_user_firstname], bring your Google Sheets to life with some colour using the magic of conditional formatting. Conditional formatting allows you to automatically change the colour formatting of a range of cells as the data is entered. This can be really handy if you are using a From to fill your Sheet with data.

You will learn:

1
Reminders for how to use filtering.
2
How to adjust conditional formatting rules
3
How to set up conditional formatting to keep track of the status of a process
4
Learn about other types of conditional formatting rules

This video is 6 minutes 10 seconds long:

Possible usage scenarios:

  • A senior leader who wants to colourise the stages students are at.
  • Quickly identify people who have not paid for something.

 

My private notes...
Click here to enter your note (this is private to you)...

Social Sharing Course

[accessally_user_firstname], If you’re enjoying this course, please share it with your friends!

Skip to toolbar