用excel工作表的条件格式标出单元格中重复数据

[[{"txt": "\u8868\u683c\u4e2d\uff0c\u6709\u5927\u91cf\u7684\u6570\u636e\uff0c\u6709\u4e9b\u6570\u636e\u662f\u91cd\u590d\u7684\uff0c\u73b0\u5728\uff0c\u9700\u8981\u628a\u8fd9\u4e9b\u91cd\u590d\u6570\u636e\u7ed9\u6807\u51fa\uff0c\u6570\u636e\u91cf\u5e9e\u5927\uff0c\u5982\u679c\u4e00\u4e2a\u4e00\u4e2a\u53bb\u627e\u7684\u8bdd\uff0c\u8017\u5c3d\u7cbe\u529b\uff1b\u5176\u5b9e\uff0c\u6211\u4eec\u53ef\u4ee5\u5229\u7528\u6761\u4ef6\u683c\u5f0f\u6765\u628a\u8fd9\u4e9b\u91cd\u590d\u7684\u6570\u636e\u627e\u51fa\u6765\u5e76\u7528\u989c\u8272\u6807\u793a\u51fa\u6765\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e3d059e833e0397224b21e5fb58630486043560a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "excel 2013"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u5c0f\u7f16\u4ee5\u4e00\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\u6f14\u793a\u4e0b\u64cd\u4f5c\u65b9\u6cd5\u3002\u4f8b\u5b50\u4e2d\u6570\u636e\u4e0d\u591a\uff0c\u4f46\u53ea\u8981\u61c2\u5f97\u65b9\u6cd5\uff0c\u6570\u636e\u65e0\u8bba\u591a\u5c11\u90fd\u80fd\u5feb\u901f\u7684\u628a\u91cd\u590d\u6570\u636e\u7ed9\u6807\u51fa\u6765\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/46a92de039723d03a15b9b33bb486143d6d4570a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9009\u4e2d\u6240\u6709\u6570\u636e\u3002\u7136\u540e\uff0c\u5728\u201c\u5f00\u59cb\u201d\u9009\u9879\u5361\u8fd9\u91cc\u7684\u201c\u6761\u4ef6\u683c\u5f0f\u201d\u4e0b\u62c9\u6309\u94ae\u70b9\u4e0b"}, {"img": ["https://exp-picture.cdn.bcebos.com/32a127723d03bbea253795fdea43d7d44931540a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/38332303bbea3e862cf9c4f65cd4483105eb550a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5f39\u51fa\u7684\u4e0b\u62c9\u83dc\u5355\u4e2d\u70b9\u201c\u65b0\u5efa\u89c4\u5219\u201d\u5f39\u51fa\u65b0\u5efa\u683c\u5f0f\u89c4\u5219\u5bf9\u8bdd\u6846\uff1b"}, {"img": ["https://exp-picture.cdn.bcebos.com/3c42a5ea3e8630487cf27261c33104ebf7a7520a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/baab208630486143c965ed848febf6a75e0f530a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\uff0c\u518d\u70b9\u4e0b\u201c\u4f7f\u7528\u516c\u5f0f\u786e\u5b9a\u8981\u8bbe\u7f6e\u683c\u5f0f\u7684\u5355\u5143\u683c\u201d"}, {"img": ["https://exp-picture.cdn.bcebos.com/3fc72e486143d7d45780a15e7da75f0f832b500a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\uff0c\u5728\u4e0b\u65b9\u7684\u8f93\u5165\u6846\u5185\u8f93\u5165\uff1a=COUNTIF($A$1:$D$5,A1)>1\u518d\u5728\u201c\u683c\u5f0f\u201d\u8fd9\u91cc\u70b9\u4e0b\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/31097f43d7d44831245a5312d40f822b75ee510a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5f39\u51fa\u8bbe\u7f6e\u5355\u5143\u683c\u683c\u5f0f\u7684\u5bf9\u8bdd\u6846\uff1b\u5728\u6846\u4e2d\u7684\u201c\u989c\u8272\u201d\u8fd9\u91cc\u7684\u4e0b\u62c9\u6309\u94ae\u70b9\u4e0b\uff0c\u5728\u5f39\u51fa\u7684\u989c\u8272\u9762\u677f\u4e2d\u9009\u62e9\u4e00\u79cd\u989c\u8272\uff0c\u5c0f\u7f16\u5728\u8fd9\u91cc\u9009\u62e9\u7ea2\u8272\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/6002c9d4483104ebd716faba092b74ee1d324e0a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\uff0c\u70b9\u51fb\u786e\u5b9a\u3002\u8fd4\u56de\u5230\u65b0\u5efa\u683c\u5f0f\u89c4\u5219\u7684\u5bf9\u8bdd\u6846\uff0c\u518d\u70b9\u786e\u5b9a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/d695563104ebf6a77dbe279effee1c324a184f0a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u70b9\u786e\u5b9a\u540e\uff0c\u8868\u683c\u4e0a\u7684\u6570\u636e\u5373\u628a\u91cd\u590d\u7684\u6570\u636e\u7528\u7ea2\u8272\u7684\u989c\u8272\u7ed9\u6807\u793a\u51fa\u6765\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/fdb4f00d3aceaad745daa957eee7340f6578b80a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/ef4c24ceaad7726b3453c052bf0f64781523b90a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "\u56fe\u7247\u6765\u6e90\u4e8e\u672c\u4eba\u5b9e\u9645\u64cd\u4f5c\u7684\u622a\u56fe\uff01"}, {"txt": "\u672c\u4eba\u4e0d\u662f\u4e13\u5bb6\uff0c\u8fd9\u53ea\u662f\u672c\u4eba\u7684\u4e00\u4e9b\u64cd\u4f5c\u7ecf\u9a8c\uff1b\u82e5\u6709\u4e0d\u5bf9\u4e4b\u5904\uff0c\u8bf7\u6d77\u6db5\uff01"}, {"txt": "\u672c\u7ecf\u9a8c\u7981\u6b62\u8f6c\u8f7d\uff01"}]]