1、首先打开一个excel电子表格,在表格中输入需要批量设置条件格式的数据。
/iknow-pic.cdn.bcebos.com/7af40ad162d9f2d34ab6ea9da7ec8a136327cc19"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7af40ad162d9f2d34ab6ea9da7ec8a136327cc19?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/7af40ad162d9f2d34ab6ea9da7ec8a136327cc19"/>
2、然后点击表格工具栏中的“条件格式”,在下拉框中选择“突出显示单元格规则”,并点击“大于”选项。
/iknow-pic.cdn.bcebos.com/c9fcc3cec3fdfc0351382dcada3f8794a4c22604"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/c9fcc3cec3fdfc0351382dcada3f8794a4c22604?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/c9fcc3cec3fdfc0351382dcada3f8794a4c22604"/>
3、然后页面会跳转出“大于”条件设置对话框,将条件设置为“4”,点击确定。
/iknow-pic.cdn.bcebos.com/6159252dd42a28347ee2f87955b5c9ea15cebf78"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/6159252dd42a28347ee2f87955b5c9ea15cebf78?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/6159252dd42a28347ee2f87955b5c9ea15cebf78"/>
4、即可将选中的单元格中所有数值大于“4”的单元格进行标红处理了。
/iknow-pic.cdn.bcebos.com/8601a18b87d6277f9359fc4a26381f30e924fc7d"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8601a18b87d6277f9359fc4a26381f30e924fc7d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/8601a18b87d6277f9359fc4a26381f30e924fc7d"/>