LoslegenKostenlos starten

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.

Diese Übung ist Teil des Kurses

<Kurs>Bedingte Formatierung in Google Sheets</Kurs>
Kurs ansehen

Übungsanweisungen

  • Apply a conditional formatting rule using a custom formula throughout the Hours/Sweater column to look at the input box in cell F4 and 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.

Interaktive praktische Übung

Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis

Übung starten