How to make excel warehouse purchase, sales and inventory form template

#How to make an Excel warehouse purchase, sales and inventory form template? The specific steps are as follows:

Example: Cell J4, >10 is yellow,

1. First complete the formula setting of J4 as "J4=G4 H4-I41"

2. Select the cell and click "Format" on the menu bar.

3. Click "Conditional Formatting" to set conditions.

4. Click "Cell Value" in the first horizontal dialog box, enter "less than or equal to" in the second dialog box, enter the customized cell "=L4" in the third dialog box, or click The telescopic button directly selects this cell.

Related recommendations: "excel basic tutorial"

5. Click "Format"--"Pattern", select red--"OK".

6. Click "Add" again, enter "between" in the second dialog box, enter the customized cell "=L4" in the third dialog box, click "Format"--"Pattern", Select bright green - "OK".

7. Same as 5, then click "Add", enter "greater than or equal to" in the second dialog box, enter the customized cell "=K4" in the third dialog box, click "Format" -- "Pattern", select yellow--"OK".

8. After entering everything, click "OK".

9. If you want to copy, just put the mouse on the lower right corner of J4 and drag the cross mark.

Note:

1. This table contains the safety stock and is relatively complete. Enter the value and the color of the table will automatically change according to the calculation results.

2. When entering a reference value, it is a relative reference, not an absolute reference (the cell "=K4" where the specified value is entered in the third dialog box cannot be preceded by a "$" sign, that is an absolute reference. Otherwise, all the formulas you copy will be based on the values ​​in the first row)

The above is the detailed content of How to make excel warehouse purchase, sales and inventory form template. For more information, please follow other related articles on the PHP Chinese website!