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, ...)
Cet exercice fait partie du cours
Conditional Formatting in Google Sheets
Instructions
- 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.
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
Commencer l’exercice