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 Sheets में Conditional Formatting
अभ्यास निर्देश
- 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.
इंटरैक्टिव व्यावहारिक अभ्यास
हमारे इंटरैक्टिव अभ्यासों में से किसी एक के साथ सिद्धांत को व्यवहार में बदलें
अभ्यास शुरू करें