• Wendy Ni

How to Use Conditional Formatting in Google Sheets

Objective Advantages

What does it mean to work on cloud? It means data can easily stay up to date because information is automatically saved as it’s typed. Are you collaborating with a team? No problem, team members can work together in real-time from their phone, tablet, or computer (offline and online).


In this blog, we go over conditional formatting. Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. Conditional formatting is ideal for when we want to narrow down information or try to get a result out of it.


The Situation

Here's an example for further understanding. There are columns for employee names (A), commissions that they're owed (B), dates for payments that were due (C), how many days those bills were past due (D). As you see when scrolling, it might seem like an endless amount of data so working with a lot of information and using this function will help you drastically to see who you still owe or when someone already got the payment, in just seconds.

Steps to Use Conditional Formatting in Google Sheets

  • In Google Sheets, click on column D (past due)

  • Click Format, and select Conditional Formatting

  • Single Color

  • Under Format rules select Greater than and type in 60 (this means if the number is greater than 60 days, it is overdue by 60 days or more)

  • Formatting style - pick a fill color and click Done

  • Click Add another rule

  • Again, under Format rules select Less than and type in 0 (which means anything less than 0 it is not due yet there is still some time)

  • Formatting style - pick a different fill color and click Done


Here's the video for more details and visual tutorial.

Check out this blog, how to use if then formula in Google Sheets.



#howto #google #analytics #data #googlesheets #sheets #dataentry #narrow #information #organized #result #conditionalformatting #rules #greaterthan #lessthan #bookkeeping #financialservices #accounting #financialgps

  • Grey LinkedIn Icon
  • Grey Facebook Icon
  • Grey Instagram Icon

©2019 All Rights Reserved 

Philadelphia, PA | New York City, NYC | hello@FinancialGPS.co