开始使用免费开始使用

Quality control

You are working in the quality control department at a plastic bottle manufacturing company.

Every day, you get a report of the bottles made the previous day.

You have received complaints from two different customers, Tricord Packaging and Helm Plastics, about leaks in the Hose-end sprayer bottles.

You need to urgently find out if any of your other customers are likely to receive faulty bottles and offer them full refunds to keep them happy.

本练习是课程的一部分

Google Sheets 条件格式

查看课程

练习说明

  • Add a conditional formatting rule using the custom formula is option to highlight all customers in column E with the Default green background that received the Hose-end sprayers.

动手互动练习

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

开始练习