Conditional formatting and data validation in a Google Sheet

6 August 2018
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


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...


Choose Industry:

Which Skills Checklist?


Nice Move Allstar!
You're about to get
awesome value in your
inbox that's going to make
life that little bit easier & sweeter!


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

First time applying for MoE Funded PLD?

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: