1、选中工作表中要应用条件格式的区域,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8601a18b87d6277ffceda23a27381f30e924fc31?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/023b5bb5c9ea15ce9237700bb9003af33b87b2d3?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/f603918fa0ec08fa2df383a556ee3d6d54fbdac5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在【开始】选项卡下单击【条件格式】按钮,在展开的列表中单击【项目选取规则】,在级联列表中单击【前10项】,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/29381f30e924b899c1e4e93a61061d950b7bf6dc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、弹出【前10项】对话框,设置好要突出项目的项目数以及格式,单击【确定】按钮,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9d82d158ccbf6c8176a9bceab33eb13533fa4012?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/2934349b033b5bb56bbdb0fc39d3d539b600bc4e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)