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.
