開始使用免費開始

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 試算表的條件格式

檢視課程

練習說明

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

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習