{"id":35566,"date":"2015-01-24T15:06:02","date_gmt":"2015-01-24T21:06:02","guid":{"rendered":"http:\/\/webirix.com\/?p=35566"},"modified":"2015-06-08T07:57:51","modified_gmt":"2015-06-08T12:57:51","slug":"formato-condicional-a-valores-duplicados","status":"publish","type":"post","link":"https:\/\/webirix.com\/en\/formato-condicional-a-valores-duplicados\/","title":{"rendered":"Conditional formatting to duplicate values"},"content":{"rendered":"<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/05\/Excel.jpg\"><img decoding=\"async\" class=\"size-full wp-image-37168 aligncenter lazyload\" data-src=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/05\/Excel.jpg\" alt=\"Excel\" width=\"306\" height=\"299\" data-srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2015\/05\/Excel.jpg 306w, https:\/\/webirix.com\/wp-content\/uploads\/2015\/05\/Excel-300x293.jpg 300w\" data-sizes=\"(max-width: 306px) 100vw, 306px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 306px; --smush-placeholder-aspect-ratio: 306\/299;\" \/><\/a><\/p>\n<p>If we want to know which values are duplicated in a column, we do the following<\/p>\n<p>First you must select the data range to which the conditional formatting will be applied:<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/filtrar-valores-unicos-01.png\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-35567 lazyload\" data-src=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/filtrar-valores-unicos-01-147x300.png\" alt=\"filtrar-valores-unicos-01\" width=\"147\" height=\"300\" data-srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/filtrar-valores-unicos-01-147x300.png 147w, https:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/filtrar-valores-unicos-01.png 268w\" data-sizes=\"(max-width: 147px) 100vw, 147px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 147px; --smush-placeholder-aspect-ratio: 147\/300;\" \/><\/a><\/p>\n<p>Then you must go to the tab\u00a0<em>Home<\/em>\u00a0and in the group\u00a0<em>Styles<\/em>\u00a0click on\u00a0<strong>Conditional format<\/strong>\u00a0and then display the menu\u00a0<em>Highlight cell rules<\/em>\u00a0and choose the option\u00a0<strong>Duplicate values<\/strong>.<\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-01.png\"><img decoding=\"async\" class=\"size-medium wp-image-35570 aligncenter lazyload\" data-src=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-01-300x289.png\" alt=\"aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-01\" width=\"300\" height=\"289\" data-srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-01-300x289.png 300w, https:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-01.png 436w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/289;\" \/><\/a><\/p>\n<p>The dialog box will be displayed\u00a0<strong>Duplicate Values<\/strong>.<\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-02.png\"><img decoding=\"async\" class=\"size-medium wp-image-35568 aligncenter lazyload\" data-src=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-02-300x104.png\" alt=\"aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-02\" width=\"300\" height=\"104\" data-srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-02-300x104.png 300w, https:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-02.png 400w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/104;\" \/><\/a><\/p>\n<p>Leave the default options and click OK. All the values are highlighted except Saturday because it is the only one in the entire list that does not repeat itself:<\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-03.png\"><img decoding=\"async\" class=\"size-medium wp-image-35569 aligncenter lazyload\" data-src=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-03-106x300.png\" alt=\"aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-03\" width=\"106\" height=\"300\" data-srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-03-106x300.png 106w, https:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/aplicar-formato-condicional-a-valores-duplicados-o-valores-unicos-03.png 193w\" data-sizes=\"(max-width: 106px) 100vw, 106px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 106px; --smush-placeholder-aspect-ratio: 106\/300;\" \/><\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>If we want to know which values are duplicated in a column, we do the following.First you must select the range of data to which the conditional formatting will be applied: Then you must go to the Home tab and in the Styles group click on Conditional Formatting and then display the Highlight cell rules menu and choose the Duplicate values option. I know \u2026<\/p>","protected":false},"author":21,"featured_media":37168,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-35566","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry"],"jetpack_featured_media_url":"https:\/\/webirix.com\/wp-content\/uploads\/2015\/05\/Excel.jpg","_links":{"self":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/35566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/comments?post=35566"}],"version-history":[{"count":2,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/35566\/revisions"}],"predecessor-version":[{"id":37363,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/35566\/revisions\/37363"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media\/37168"}],"wp:attachment":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media?parent=35566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/categories?post=35566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/tags?post=35566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}