Project 1 of 7: Tailspin Toys
You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.
On the “Orders” worksheet, use an automatic formatting method to format cells in the “OrderTotal” column that contain above-average values by applying Green Fill with Dark Green Text. Use a technique that automatically updates the formatting if the column values change.
Answer: See explanation below.