You can highlight the entire row by selecting the entire row (A2.C2) in step 1. To highlight Item instead of Current Inventory, simply select cell A2 in step 1. With a quick glance, you can determine which items to order. When the current inventory dips below (or is equal to) the reorder amount, Excel highlights that cell. Select cells B3.B4 to apply the conditional format to the remaining items.With cell B2 still selected, click Format Painter.Click OK to close the Conditional Formatting dialog box.Click the Format button and select red from the Patterns tab, and click OK.In other words, when the value in B2 is less than or equal to the value in C2, apply the format. Next, enter the following formula, =B2In the resulting dialog box, choose Formula Is from the first control’s dropdown list.When applying this to your own worksheet, select the first value in the column (not the column’s label text).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |