EXCEL中的IF语句是逻辑判断函数,无法完成该需求,但可以使用条件格式完成需求。
1、首先打开Excel办公软件,演示所用版本为Office家庭与学生版 2016,其他版本亦可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f703738da97739121d4ffc49f6198618367ae2a9?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/738b4710b912c8fcac7f8fe5f2039245d688210d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在开始菜单中找到条件格式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3b292df5e0fe9925812112783aa85edf8db171ec?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/f9198618367adab4f8f2606b85d4b31c8701e4fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在弹出的界面上选择比较单元格,选择C4后删除数字4前面的绝对定位符号“$”,然后使用填充柄只填充格式即可完成题目需求,由结果可知,该方法可行。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/63d9f2d3572c11df62f3c50b6d2762d0f703c2fc?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/314e251f95cad1c8fbdf860f713e6709c93d51b5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)