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 試算表的條件格式
練習說明
- 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.
