Set automatic color change in EXCEL

This method was learned from friends. When I used an EXCEL table (I used office2010 version) to purchase and store items, I was dazzled by numbers, especially numbers,. At this time, it would be much easier to remind you of the color change.

This article mainly describes how to use cell color changes in the inventory and purchase forms to remind you that the quantity of a certain item is reduced to a certain value or the replenishment is not enough, which is more convenient.

Here is an example:

Taking the first material and stabilizer as an example, if the existing stock is 5575 kg, we set the alert stock quantity to 2000 kg, that is, when the stock quantity of this material is 2000 kg, or less than 2000kg, it will change color, and we will be able to understand it intuitively at this time.

Perform the following operations:

1. Existing inventory in the point, the cell of 5575;

 

2. Click Start ",

3. Find the "condition format" on the right ";

 

4. Open "condition format" and click "create rule ";

 

5. Select "set format only for cells containing the following content ";

 

6. In the "cell value" setting, select "less than or equal ";

 

7. click the button next to it;

 

8. Select the previously set "alert inventory" 2000;

 

9. After the selection is complete, the format rules are automatically displayed, and then click the button on the right;

 

10. After setting the format, click "OK ";

 

11. When the stock of the material is 1900, or less than 2000, the cell turns red;

 

12. When the inventory increases by more than 2000, the red color disappears;

 

Summary: This method is mainly used for notification of a small number of items. If there are too many items, you need to set them one by one. You can set the column unless the alert repository is the same.

 

If this article is not correct, please point out, thank you!

From Bin-ng blog