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.