Negative variances
Well, this is the final test of how well you can apply your conditional formatting skills!
Let's just add a red background to the lines that are showing a negative variance of less than -10% and -$10,000.
Your sheet already contains the conditional formatting from the previous exercise, as this should also be a part of your report. Then, you can share the report with your boss with a glowing smile on your face.
本練習屬於課程
Google 試算表的條件格式
練習說明
- Add a conditional formatting rule using a custom formula that highlights each row, column
AthroughF, that falls below -10% (-0.10) and -$10,000 (-10000) variance.- For each criteria in the
ANDfunction, fix the column with a$(e.g.$F2) but do not fix the row (e.g.$F$2).
- For each criteria in the
- Use a custom formula and use the Default red background to show negative variances.
