Conditional Formatting in Google Sheets - Step by Step
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add Conditional Formatting in Google Sheets - Step by Step to your Wishlist.

Add to Wishlist

Conditional Formatting in Google Sheets - Step by Step

Create interactive and user friendly Google Sheets to improve customer or associate understanding of data.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Created by Tim Kope
Last updated 4/2017
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 34 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use Conditional Formatting with ease to create Google Spreadsheets that are functional and user friendly.
  • Use every type of Conditional Formatting with Ease and without confusion.
View Curriculum
Requirements
  • You should have a basic knowledge of Google Sheets - know how to open documents and fill cells.
Description

Have you ever seen spreadsheet rows change color as a deadline approaches? As a payment became late? 

Do you like the convenience of cells highlighting if there is a certain word or number in them?

Conditional Formatting is an excellent tool that I use on a daily basis in many different ways.

I use conditional formatting in my Google Spreadsheets to:

  • indicate items sold.
  • indicate items sold at discount
  • highlight customers in a list
  • highlight customers I have not spoke to in more than a year

There are many more applications for conditional formatting of course.

In this course, I will show you each and every way conditional formatting is used. This is a very confusing topic, if you never used conditional formatting before. By walking through each option, you will get a clear understanding of the process and easily use any of the necessary techniques.

Who is the target audience?
  • This course is for anyone who wants to improve their Google Sheets skills.
  • Professionals who use Google Sheets to improve productivity and sales.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Welcome!
1 Lecture 00:41
+
Conditional Formatting Based Off Text
8 Lectures 07:27


Text Contains
01:04

Text Contains - Advanced
00:53

Text Does Not Contain
00:38

Text Starts With
01:00

Text Ends With
01:07

Text is Exactly
01:18
+
Conditional Formatting Based Off Date
3 Lectures 05:17

Date is Before
01:05

Date is After
00:57
+
Conditional Formatting Based off Number
8 Lectures 06:43
Greater Than
00:53

Greater Than or Equal To
00:50

Less Than
00:45

Less Than or Equal to
00:39

Is Equal to
00:45

Is Not Equal to
01:03

Is Between
01:03

Is Not Between
00:45
+
Conditional Formatting Based off Custom Formula
5 Lectures 09:02
Benefits of Using Custom Formulas .. and Lets Get Started!
00:48


How to Highlight One Row - Service Due Today!
03:46

Service is Not Due As Of Today
01:16

About the Instructor
Tim Kope
0.0 Average rating
0 Reviews
8 Students
3 Courses
Spreadsheet Master

Thank you for visiting my profile!

As a sales enthusiast, I always try to provide customers with the options that benefit them the most.

i also spent quite a bit of time building very elaborate charts to keep charge of my sales.

I am very interest in teaching you how to build elaborate charts. If you want to learn any aspect of creating a Google Sheets spreadsheet, let me know! I'll create a new video series for you!