excel怎么两列数据一样才变色

发布网友 发布时间：3小时前

我来回答

共1个回答

热心网友 时间：3小时前

excel两列数据同行比较，不一样即填充红色，使用条件格式即可实现。
方法步骤如下：
1、打开需要操作的EXCEL表格，选中两列数据，点击开始选项卡中的“条件格式”“新建规则”。
/iknow-pic.cdn.bcebos.com/c995d143ad4bd113f0badedb54afa40f4afb05e7"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/c995d143ad4bd113f0badedb54afa40f4afb05e7?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/c995d143ad4bd113f0badedb54afa40f4afb05e7"/>
2、选择“使用公式确定要设置格式的单元格”，然后输入公式=$A1$B1，点击格式进行相关格式设置。
/iknow-pic.cdn.bcebos.com/b17eca8065380cd76e73cb04af44ad34588281ee"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b17eca8065380cd76e73cb04af44ad34588281ee?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/b17eca8065380cd76e73cb04af44ad34588281ee"/>
3、切换到填充标签页，选中红色，然后确定返回上一层设置界面。
/iknow-pic.cdn.bcebos.com/2cf5e0fe9925bc316c03687150df8db1ca1370f8"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/2cf5e0fe9925bc316c03687150df8db1ca1370f8?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/2cf5e0fe9925bc316c03687150df8db1ca1370f8"/>
4、点击确定即可。
/iknow-pic.cdn.bcebos.com/b83b504fc2d5629946b904e91190ef77c66c88"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b83b504fc2d5629946b904e91190ef77c66c88?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/b83b504fc2d5629946b904e91190ef77c66c88"/>
5、返回EXCEL表格，发现excel中，两列数据同行比较，不一样即填充红色操作完成。
/iknow-pic.cdn.bcebos.com/94cad1c8a786c9172e543bd0c73d70cf3ac75787"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/94cad1c8a786c9172e543bd0c73d70cf3ac75787?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/94cad1c8a786c9172e543bd0c73d70cf3ac75787"/>