1、首先打开Excel软件然后选中两列数值,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/838ba61ea8d3fd1f434734963e4e251f94ca5fcb?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/cb8065380cd791232e7502d8a3345982b3b78081?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/0dd7912397dda14416defa1ebcb7d0a20df48643?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/9a504fc2d562853530ce438d9eef76c6a7ef6374?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、然后打开后在公式内输入“=A1=MIN($A1:$B1)”,输入完后点击下方的格式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/03087bf40ad162d981eff3b01fdfa9ec8a13cd1d?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/d043ad4bd11373f0be69fe33aa0f4bfbfaed04c3?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/91ef76c6a7efce1b46d75966a151f3deb58f659a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)