{"id":2424,"date":"2017-07-18T07:50:50","date_gmt":"2017-07-18T07:50:50","guid":{"rendered":"http:\/\/codethataint.com\/blog\/?p=2424"},"modified":"2017-07-18T13:49:42","modified_gmt":"2017-07-18T13:49:42","slug":"using-conditional-formatting-to-find-the-matching-rows","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/using-conditional-formatting-to-find-the-matching-rows\/","title":{"rendered":"Using Conditional Formatting to find the Matching Rows"},"content":{"rendered":"<p><strong>How to highlight rows which have different row value of one Column<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codethataint.com\/blog\/wp-content\/uploads\/2017\/07\/ConditionalFormatting.png\" alt=\"null\" width=\"522\" height=\"158\"\/><\/p>\n<p><strong>The Steps are as Below<\/strong><br \/>\nBelow is the way to highlight the rows based on a change in value in the single column.The Column considered is <strong>SNo<\/strong><\/p>\n<p><strong>Steps<\/strong><\/p>\n<ul>\n<li>Select the whole DataSet LookUpArray on which the conditional formatting to be applied<\/li>\n<li>Click on Conditional Formatting<\/li>\n<li>Click on new Rule<\/li>\n<li>Use a formula to determine which cells to format<\/li>\n<li>Note : The formula used is relative formula <em>=ISNA(MATCH($D2,$A$2:$A$7,FALSE))<\/em><\/li>\n<li>Use the format option to apply the Conditional format on the cells<\/li>\n<li>The same could be seen in Conditional Formatting->Manage Rules for future rule edits<\/li>\n<\/ul>\n<p><strong>In the below image Rows 4 and 7 are highlighted because of mismatch in SNo and 5 is highlighted because of mismatch in fruit name<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codethataint.com\/blog\/wp-content\/uploads\/2017\/07\/ConditionalFormattingFullSteps.png\" alt=\"\" width=\"1000\" height=\"2815\"\/><\/p>\n<p><strong>Checking for Identical rows in two tables with more than one column<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codethataint.com\/blog\/wp-content\/uploads\/2017\/07\/FormattingMoreRows.png\" alt=\"\" width=\"521\" height=\"190\"\/> <\/p>\n<pre>\r\n =ISNA(MATCH($D2,$A$2:$A$7,FALSE)&MATCH($E2,$B$2:$B$7,FALSE) )\r\n<\/pre>\n<p><strong>Steps<\/strong><\/p>\n<ul>\n<li>First we are checking if the rows in D2 is same as on in A2 to A7<\/li>\n<li>Second we are checking if the rows in E2 is same as on in B2 to B7<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>How to highlight rows which have different row value of one Column The Steps are as Below Below is the way to highlight the rows based on a change in value in the single column.The Column considered is SNo Steps Select the whole DataSet LookUpArray on which the conditional formatting to be applied Click on&hellip; <a href=\"https:\/\/codethataint.com\/blog\/using-conditional-formatting-to-find-the-matching-rows\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[76],"tags":[],"class_list":["post-2424","post","type-post","status-publish","format-standard","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/2424","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=2424"}],"version-history":[{"count":6,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/2424\/revisions"}],"predecessor-version":[{"id":2433,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/2424\/revisions\/2433"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=2424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=2424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=2424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}