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, ...)
이 연습은 강의의 일부입니다
Google Sheets에서 조건부 서식
연습 안내
- 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.
