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.
Latihan ini merupakan bagian dari kursus
Format Bersyarat di Google Sheets
Instruksi latihan
- 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.
Latihan interaktif langsung
Ubah teori menjadi aksi dengan salah satu latihan interaktif kami
Mulai latihan