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.
この演習はコースの一部です
Google スプレッドシートの条件付き書式
演習の手順
- 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
