Blog

Conditional formatting and data validation in a Google Sheet

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:

 

 


FREE PDF DOWNLOAD

Are you at a beginner, intermediate, or advanced level? This skills checklist will help you find out.

We will only send you awesome stuff!

×

FREE PDF DOWNLOAD

Are you at a beginner, intermediate, or advanced level? This skills checklist will help you find out.

We will only send you awesome stuff!

×

Our trainers pull together the best of the best, stay up to date with the latest blog posts, new tips and tricks, something we think you'll like, something to make you think and much more...

SUBSCRIBE BELOW NOW

Nice one! Awesome content is coming your way :)