1、首先打开一份需要编辑的表格,例如当库存低于下限的时候,就会显示颜色并提出警告。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bba1cd11728b47108f414b85cdcec3fdfc032308?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选中需要设置的单元格,点击公式里面的插入函数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d439b6003af33a87253cb653c85c10385343b522?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在插入函数里面选择if函数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bf096b63f6246b60bbbd043de5f81a4c500fa2cc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、确定了函数之后,在函数参数里面按照下图填入相关的条件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d833c895d143ad4b8a82f0898c025aafa50f06ce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、输入完毕后确定,就可以看到超出刚设置的条件范围的就会弹出紧急采购的字样。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/08f790529822720ea28b54b375cb0a46f21fab36?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、接着点击上上角的条件格式选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e4dde71190ef76c65d2c4d629316fdfaae5167f9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、在条件格式里选择等于,然后在为等于一下值的单元格设置格式一栏中输入紧急采购,并将此字体样式设置为红色即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/32fa828ba61ea8d3dc84c24d990a304e241f58d0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、最后点击确定就可以看到超出范围的值显示红色了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100886d4e687c8b4710b8122f81?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)