Using a custom formula to highlight a row

In this task, rather than just highlighting individual cells, you will highlight any rows of your data when the value of the Volume is less than 3,000.

To accomplish this, you can use a custom formula in the form of =$A1<x, where in this example A1 is the first cell in the column you want to check, and x is the value that you are comparing the cell with.

For example, =$A1<5000 would apply the conditional formatting to all rows where the value in column A is less than 5000.

This exercise is part of the course

Data Visualization in Google Sheets

View Course

Exercise instructions

Create a new conditional formatting rule that highlights rows when the value in the Volume column is less than 3000.

Highlight all of the data in the range A17:G26 and create a new conditional format rule, and use the 'Custom formula is' option to specify a formula.
The formula should use partial absolution (i.e. $G17) to compare the volume column with the value of interest (in this case,3000).
Set the formatting options below so that the text is "red", and bold when the condition is fulfilled. The 'Fill color' should be set to 'None'!
If you're struggling with your formula, try adapting the example provided above!

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise