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 試算表的條件格式
練習說明
- 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.
