How to Use Conditional Formatting in Google Sheets
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.
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
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