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).

เปลี่ยนทฤษฎีให้เป็นการลงมือทำด้วยแบบฝึกหัดเชิงโต้ตอบหนึ่งในของเรา