Google: How to Apply Conditional Formatting in Google Sheets
- |
- 24 steps |
- 43 seconds
1
Navigate to a Google Sheet
2
Click the column you'd like to format based on a condition.
3
Click "Format"
4
Click "Conditional formatting"
5
Click this field to narrow down the exact cells you want to be affected by this conditional formatting. For this spreadsheet, the numbers start in cell F4 and end in cell F514, so I update that as shown below.
6
Click the drop down box to determine what has to happen for the cell to be formatted (this is the "condition" that needs to be met).
7
For this sheet, I want to color code any cell that has a number Equal to or Higher Than 37, so I click "Greater than or equal to"
8
Click the "Value or formula" field and type the value (37, in my case)
9
I want to change the color of the cell if it matched the above condition. You can also bold, italicize, underline, strikethrough, and change font color of whatever is in the cell.
10
Here I am choosing the color I want the cell to be if it matches that condition.
11
Click "Done" to apply the condition.
12
Click here to add additional conditions for the column.
13
Repeat the step of narrowing down the cells you want to format, if applicable.
14
My next condition is to check if the number in the cell is less than or equal to 23. I click "Less Than or Equal To" to apply this condition.
15
Click the "Value or formula" field and type in the number (23, in my case).
16
Click here to select a color for this condition.
17
Click "Done"
18
Click here to continue to add conditions (I require 3 conditions. The 3rd is shown below).
19
Narrow down cells again, if applicable.
20
For this last condition, I want to color the remaining range of numbers that fell between my "low" of 23 and "high" of 37. I select "Is between"
