開始使用免費開始

Creating a simple rule to highlight cells

In this task, you want to highlight volume of shares from the SM8 Smart Marine Systems ASX that exceed 60,000. Using conditional formatting, you can create a rule that will highlight any numbers that are greater than a specified amount.

本練習屬於課程

Google Sheets 的資料視覺化

檢視課程

練習說明

  • Highlight the Volume data in G17:G26 and add a conditional formatting rule that will format cells "light yellow 2" if the value in them is greater than 60,000.

動手互動練習

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

開始練習