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
