Explainry Tutorials to Expert in IT

Conditional formatting in Google Sheets

In this lesson, we will learn basis of conditional formatting in Google Sheets with screenshots and step-wise approach.

What is conditional formatting?

The conditional formatting feature allows you to highlight certain cells, columns or rows based on certain conditions you set. For example, you may set a condition “if cell A1 is greater than 2, then change the cell color to green” etc.

How to add a formatting rule with one condition

Suppose you have month-wise sale record of salesman. You want to highlight those salesman which have less than 15 order within the given period. For this do the following steps:

1- Select the range of cells: F3:F9.

2- In the Format tab, select the conditional formatting.

3- A toolbar will open to the right side.

4- Create a rule i.e. highlight those salesman which have less than 15 order within the given period. For this, Select “Less than” option from the Format rules and input 15. Click Done.

5- Result. You will find those cells highlighted with less than 15 value.

For more explainry examples on conditional formatting click here.




Copyright © 2016 - 2020 Explainry.com | All Rights Reserved