开始使用免费开始使用

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.

动手互动练习

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

开始练习