Positive variances
Oh boy, we're getting close to your crowning achievement.
Let's level up this report by showing each line that increased over 10% and $10,000.
Recall that the AND function accepts two or more arguments, returning TRUE if they are all TRUE and FALSE if any of the arguments are FALSE. The function uses the following format:
AND(first argument, second argument, ...)
Diese Übung ist Teil des Kurses
Conditional Formatting in Google Sheets
Anleitung zur Übung
- Add a conditional formatting rule using a custom formula that highlights each row, column
AthroughF, that exceeds $10,000 (10000) and 10% (0.10) 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 the purposes of this exercise, make sure to pass the arguments to the
ANDfunction in the order in which the columns appear (i.e.EbeforeF).
- For each criteria in the
- Use the Default green background in your custom formula to show the positive variances.
Interaktive Übung
In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.
Übung starten