开始使用免费开始使用

Positive and negative

You may have gone through the last set of exercises wondering why we were ignoring the negative variances.

Well, let's take a look at them while also highlighting the positive variances.

Using the OR function, let's update the dollar variance formatting to also catch variances under -$1,000.

Then, update the percentage variance highlighting to also highlight variances under -10% on this same sheet.

本练习是课程的一部分

Google Sheets 条件格式

查看课程

练习说明

  • Update the custom formula applied to the range D8:D20 with the OR() function to look for amounts greater than $1000 or less than $-1000.

  • Update the custom formula that is applied to E8:E20 to also highlight percentages under -10% (-0.10).

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习