Highlighting SMALL
Now lets use the SMALL function as your custom formula for conditional formatting.
Let's highlight the bottom three rates of Hours / Sweater.
Latihan ini merupakan bagian dari kursus
Format Bersyarat di Google Sheets
Instruksi latihan
- Apply a conditional formatting rule using a custom formula throughout the
Hours/Sweatercolumn to look at the input box in cellF4and highlight the bottom three rates with the Default green background.- When you use
$s to fix the references, be sure to only fix the row numbers and not the column letters.
- When you use
Latihan interaktif langsung
Ubah teori menjadi aksi dengan salah satu latihan interaktif kami
Mulai latihan