Ranking your goals
You have added a rank for each goal with # 1 being the most important and # 11 being the least important.
You're going to choose the number of goals that you want to focus on depending on your mood every day. Your mood today is moderately motivated.
That means that you'll think about the top five goals as you go about your day.
本練習屬於課程
Google 試算表的條件格式
練習說明
- Build a conditional formatting rule using the
SMALLfunction to highlight the checkmark in columnBand the ranking number in columnCwith the Default green background for tasks ranked 1-5.- This formula should pick five because it will look at the value in the Input Box in cell
F5. - Start the formula with
=$C5and use fixed column and row references for the rest of the formula withinSMALL(e.g.$A$1).
- This formula should pick five because it will look at the value in the Input Box in cell
