Search and Color

Basic Exercise


A spices shop made a discount campaign to promote the opening of a new store. To that purpose some products were sold for US$ 1,00 (one dollar) to attract more clients. In this exercise, you need to locate the items sold for one dollar in the worksheet. Once the items are found color to green the background of both item name and selling price cells for each of those items Additionally you need to write "Sold Out" by the side of those items (in column "C").

Suggested Concepts:

Remember that in most cases there is more than one way to solve the exercise.

Hint: Condition the loop to find the desired value and subsequently adjust the range.

Show Answer

Download exercise Download answer is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2023 SuperExcelVBA | ABOUT

Protected by Copyscape