{"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 loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-37168 aligncenter\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/05\/Excel.jpg\" alt=\"Excel\" width=\"306\" height=\"299\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2015\/05\/Excel.jpg 306w, https:\/\/webirix.com\/wp-content\/uploads\/2015\/05\/Excel-300x293.jpg 300w\" sizes=\"auto, (max-width: 306px) 100vw, 306px\" \/><\/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 loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-35567\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2015\/01\/filtrar-valores-unicos-01-147x300.png\" alt=\"filtrar-valores-unicos-01\" width=\"147\" height=\"300\" 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\" sizes=\"auto, (max-width: 147px) 100vw, 147px\" \/><\/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 loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-35570 aligncenter\" 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\" 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\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/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 loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-35568 aligncenter\" 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\" 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\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/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 loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-35569 aligncenter\" 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\" 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\" sizes=\"auto, (max-width: 106px) 100vw, 106px\" \/><\/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":"open","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}]}}