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 Sheets 条件格式
练习说明
- 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
