使用条件格式,大于0的突出红色,小于0的突出绿色即可(0不是正数也不是负数,所以无需设置大于等于条件格式),具体操作步骤如下:
所需材料:Excel。
一、打开Excel文件,点击选中A列,进入“开始选项”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8ec8a13632762d02f51d4d1afec08fa513dc675?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
二、点击开始选项下的“条件格式”,下拉菜单内点击“空出显示单元格规则”,子菜单内点击“大于 ”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e1fe9925bc315c6073d01b8182b1cb1349547712?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
三、大于值输入“0”,设置为“浅红色填充”,点击“确定”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2fdda3cc7cd98d1027ed7c5f2e3fb80e7bec90a6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
四、重新再新建一个“小于”的突击显示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/eaf81a4c510fd9f92d7925072a2dd42a2834a476?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
五、小于值内也输入“0”,设置为“绿色填充”,点击“确定”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/241f95cad1c8a786af433a606809c93d70cf5076?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
六、效果如下图,在A列中输入正数时显示红色填充,负数时绿色填充。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9d82d158ccbf6c81d60f5c86b33eb13533fa40a7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)