Microsoft Excel Functions & Formulas

Use conditional formats to indicate

unavailable products

When checking the existing inventory of a warehouse, it needs to

be determined which products are out of stock so they can be

ordered. To get a better overview of the inventory, all products that

are unavailable need to be marked by using conditional formatting.

The formatting criterion is taken from column D, which indicates

whether or not a product is available.

4

To mark all products that are out of stock:

1. Copy the table shown in Figure 10-3 into a worksheet and

select cells A2:D13.

2. On the Format menu, click Conditional Formatting.

3. Select Formula Is and type the following formula:

=$D2="no" ...