将大于600的EXCEL数据设置为红色,小于600的EXCEL数据设置为蓝色具体步骤如下:
1.首先打开要编辑的Excel表格,进入编辑页面。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2e2eb9389b504fc259e46c7bf5dde71190ef6d11?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/cb8065380cd79123e65b480abd345982b2b78011?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3.然后在弹出窗口中输入“600”,设置为“红色文本”。按回车确认。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d8f9d72a6059252d8cacc17a249b033b5bb5b911?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/91529822720e0cf3904c92851a46f21fbe09aa11?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5.然后输入“600”,在设置中打开“自定义格式”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/54fbb2fb43166d2270ccc9ea562309f79052d211?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/a1ec08fa513d26976068d42345fbb2fb4316d811?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7.然后将大于600的输入数据输入到单元格中会变成红色,小于600的输入数据会变成蓝色。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/63d0f703918fa0ec3e7cb873369759ee3d6ddb11?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)