Conditional formatting and data validation in a Google Sheet

Published
6 August 2018
by
Adrian Francis

Often when we have a spreadsheet with a lot of data it can be hard to quickly find what you want. Sometimes the data that has been entered is not in a format you can use easily. By using colour and restricting the data that can be entered into the Google Sheet this hurdle can be lowered. Within a Google Sheet there are two functions that can help:

1. Conditional formatting, which allows you to colour cells based on a condition like the size of a number, or even apply a colour scale to bring more clarity to your Google Sheet.
2. Data Validation, which allows you to create a drop-down list of items or regulate what data can be entered in a cell.

Watch this video to learn how to use these tools to further develop your skills in gaining insights into your data and to build a Google Sheet that can be used easily by others.

Want to learn how to easily find and analyse data in #Google #Sheets? Watch this video on conditional formatting and data validation. Great tips for great solutions! Click To Tweet

 

Check out some other posts on using Google Sheets:

 

 


Recent Posts

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...

 

Sign Up Now
To Get The Latest Updates

 

Pop in your details below and we'll send you the PLD Checklist 📧

 

Get the Latest Blog Posts, New Tips And Tricks

 

NSW DoE Leadership Webinars

 

NSW DoE Leadership Webinars

 

Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: