Additional rule
Conditional formatting rules can be layered on top of each other.
In this case, you are wondering if there is a correlation between high sales and the region in which the sales rep operates.
You will apply another conditional formatting rule in the same set of data that we used in the last excercise.
이 연습은 강의의 일부입니다
Google Sheets에서 조건부 서식
연습 안내
- With the range of
B2toB14highlighted, add a new rule in the conditional formatting window to the right. - Choose "Text contains" again as the value for the drop down under Format cells if and type South into the box.
- Leave the Formatting style as the Default green background, and click Done.
