1、电脑打开Excel表格,然后选中要设置颜色的一列。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/472309f790529822391ae92ed9ca7bcb0a46d436?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/622762d0f703918f9beded275f3d269759eec41b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、进入其他规则页面后,选中使用公式确定要设置格式的单元格,然后输入公式=$D1="通过",点击格式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d1a20cf431adcbeff608aeeba2af2edda3cc9f1b?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/5243fbf2b2119313c3ad2e5d6b380cd790238d75?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/7c1ed21b0ef41bd54f5238195fda81cb38db3dde?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/b999a9014c086e063057eea60c087bf40bd1cb64?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、然后继续给这一类添加一个未通过的格式,公式为=$D1="未通过",格式为红色。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/503d269759ee3d6d14f857264d166d224f4ade25?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/09fa513d269759ee7caeb126bcfb43166c22df65?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)