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.
이 연습은 강의의 일부입니다
Google Sheets로 배우는 데이터 시각화
연습 안내
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:G26and 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!
