{"id":1432,"date":"2018-04-18T14:50:48","date_gmt":"2018-04-18T06:50:48","guid":{"rendered":"http:\/\/owa.sodexo-cn.com\/blog\/?p=1432"},"modified":"2018-04-18T14:58:50","modified_gmt":"2018-04-18T06:58:50","slug":"excelcompare-the-data-differences-between-different-tables-and-the-conditional-formatting-can-help-you-get-it-done","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=1432","title":{"rendered":"[Excel]Compare the data differences between different tables, and the conditional formatting can help you get it done"},"content":{"rendered":"<h2><span style=\"color: #333333;\">Case description<\/span><br \/>\n<img decoding=\"async\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/04\/041818_0650_ExcelCompar1.png\" alt=\"\" \/><span style=\"color: #333333; font-family: \u5fae\u8f6f\u96c5\u9ed1; font-size: 16pt;\"><br \/>\n<\/span><\/h2>\n<p style=\"background: white;\"><span style=\"color: #333333; font-family: \u5b8b\u4f53; font-size: 12pt;\">Suppose I have a raw data and a data that needs to be compared. I would like to compare two data differences to find the difference in information. How do I work with conditional formatting?<br \/>\n<\/span><\/p>\n<h2><span style=\"color: #333333;\">Steps<br \/>\n<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1435\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/04\/8.gif\" alt=\"\" width=\"1001\" height=\"649\" \/><\/p>\n<h2><span style=\"color: #333333;\">Step 1<br \/>\n<\/span><\/h2>\n<p style=\"background: white;\"><span style=\"color: #333333; font-family: \u5b8b\u4f53; font-size: 12pt;\">Select the <strong>original data<\/strong> or the <strong>data you want to compare<\/strong>, create a new rule, and select <strong>use a formula to determine which cells to format<\/strong>.<br \/>\n<\/span><\/p>\n<h2><span style=\"color: #333333;\">Step 2<br \/>\n<\/span><\/h2>\n<p style=\"background: white;\"><span style=\"color: #333333; font-family: \u5b8b\u4f53; font-size: 12pt;\">Enter the =a12 &lt;&gt; A3 to determine if the corresponding is equal. To compare the entire area, delete the $ to ensure a relative reference to the cell.<br \/>\n<\/span><\/p>\n<h2><span style=\"color: #333333;\">Step 3<br \/>\n<\/span><\/h2>\n<p style=\"background: white;\"><span style=\"color: #333333; font-family: \u5b8b\u4f53; font-size: 12pt;\">Set a specific format for the differentiated cells. Complete!<br \/>\n<\/span><\/p>\n<p style=\"background: white;\"><img decoding=\"async\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/04\/041818_0650_ExcelCompar2.png\" alt=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Case description Suppose I have a raw data and a data t &#8230; <a title=\"[Excel]Compare the data differences between different tables, and the conditional formatting can help you get it done\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=1432\" aria-label=\"\u9605\u8bfb [Excel]Compare the data differences between different tables, and the conditional formatting can help you get it done\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1432","post","type-post","status-publish","format-standard","hentry","category-tips"],"views":3124,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1432"}],"version-history":[{"count":2,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1432\/revisions"}],"predecessor-version":[{"id":1437,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1432\/revisions\/1437"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}