Formatting an entire row
Let's put what you just learned into action.
This sales report is not unlike the others. The difference here is that this sales report contains your own sales.
Of course, you want to honk your horn by highlighting the entire line whenever you had a sale, right?
If you only highlighted the cells from one column, readers of this report may miss how great you are.
Bu egzersiz, kursun bir parçasıdır
Google Sheets'te Koşullu Biçimlendirme
Egzersiz talimatları
- Add a conditional formatting rule that uses a custom formula to highlight all sales by
Morganwith the Default green background.- The range in the "Apply to range" box should be the entire range that you will be highlighting, not just the column with the names. Therefore, the range should be
A2:F24.
- The range in the "Apply to range" box should be the entire range that you will be highlighting, not just the column with the names. Therefore, the range should be
Uygulamalı etkileşimli egzersiz
Teoriyi etkileşime dönüştürün, interaktif egzersizlerimizden biriyle
Egzersize başla