Greater than
In this scenario, you are analyzing the inventory in your warehouse and you would like to see which items are over-stocked.
You have decided that any items that you have more than 300 of need to be marked down with a "clearance" price and you need to show which items these are.
本练习是课程的一部分
Google Sheets 条件格式
练习说明
- Highlight range
B2toB16and add a new rule in the conditional formatting window to the right. - Under Format cells if, select "Greater than" as the option and type 300 into the box.
- Leave the Formatting style as the Default green background, and click Done.
