{"id":274,"date":"2023-11-07T16:11:29","date_gmt":"2023-11-07T16:11:29","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/"},"modified":"2023-12-25T10:24:18","modified_gmt":"2023-12-25T10:24:18","slug":"comparar-columnas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/","title":{"rendered":"\u00bfc\u00f3mo comparar dos columnas en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-4123554304\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>En Excel, el formato condicional es la forma m\u00e1s sencilla de comparar dos columnas. Con esto puedes comparar dos columnas de varias maneras. En este tutorial, aprenderemos varios m\u00e9todos para utilizar el formato condicional para la comparaci\u00f3n de columnas.<\/p>\n<h2 class=\"wp-block-heading\"> Comparar dos columnas por fila<\/h2>\n<p> Con este m\u00e9todo, puede comparar las dos celdas en cada fila de las columnas y resaltar las celdas con el mismo valor.<\/p>\n<ol>\n<li> Primero, seleccione ambas columnas de los datos. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"1-seleccionar-ambas-columnas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"1-select-both-columns\" width=\"290\" height=\"335\"><\/li>\n<li> A continuaci\u00f3n, vaya a la pesta\u00f1a Inicio &gt; Formato condicional &gt; Nueva regla. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"2-formato-condicional-nueva-regla\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-nouvelle-regle-de-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-conditional-formatting-new-rule\" width=\"296\" height=\"397\"><\/li>\n<li> Desde all\u00ed, haga clic en \u00abUsar una f\u00f3rmula para determinar qu\u00e9 celdas formatear\u00bb. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"3-selecciona-usa-una-f\u00f3rmula-para-determinar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionnez-utiliser-une-formule-pour-determiner.png\" sizes=\"auto, \" srcset=\"\" alt=\"3-select-use-a-formula-to-determine\" width=\"563\" height=\"202\"><\/li>\n<li> Luego, en la barra de f\u00f3rmulas, ingrese la f\u00f3rmula =$A2&lt;&gt;$B2, luego haga clic en \u00abFormato&#8230;\u00bb para especificar el formato. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"4-ingrese-la-f\u00f3rmula-y-especifique-el-formato\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-entrez-la-formule-et-specifiez-le-format.png\" sizes=\"auto, \" srcset=\"\" alt=\"4-enter-formula-and-specify-format\" width=\"565\" height=\"209\"><\/li>\n<li> Una vez que haya especificado el formato, haga clic en Aceptar para aplicar el formato condicional y en Aceptar nuevamente para cerrar el Administrador de reglas. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"5-cerrar-el-administrador-de-reglas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-fermer-le-gestionnaire-de-regles.png\" sizes=\"auto, \" srcset=\"\" alt=\"5-close-the-rules-manager\" width=\"580\" height=\"217\"><\/li>\n<\/ol>\n<p> Y en el momento en que haces clic en Aceptar, resalta las celdas en ambas columnas donde los valores son iguales. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90468\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-cellules-en-surbrillance-avec-les-memes-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"celdas resaltadas con los mismos valores\" width=\"280\" height=\"331\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Compare todos los valores en todas las columnas<\/h2>\n<p> A diferencia del primer m\u00e9todo, puedes resaltar ambos valores que est\u00e1n duplicados en las columnas. Y para eso, seleccione ambas columnas y vaya a la pesta\u00f1a Inicio &gt; Formato condicional &gt; Reglas de resaltado de celdas &gt; Valores duplicados. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90469\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-selectionner-les-valeurs-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"seleccionar valores duplicados\" width=\"530\" height=\"440\"><\/figure>\n<\/div>\n<p> En el cuadro de di\u00e1logo Duplicar valores, seleccione los valores que desea resaltar y el color que desea aplicar. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90470\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-selectionnez-doublon-pour-mettre-en-surbrillance-les-doublons.png\" sizes=\"auto, \" srcset=\"\" alt=\"seleccionar-duplicado-para-resaltar-duplicados\" width=\"388\" height=\"160\"><\/figure>\n<\/div>\n<p> Al final, haga clic en Aceptar para aplicar el formato condicional. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90471\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-valeurs-en-double-mises-en-evidence.png\" sizes=\"auto, \" srcset=\"\" alt=\"valores duplicados resaltados\" width=\"285\" height=\"324\"><\/figure>\n<\/div>\n<p> En el momento en que haga clic en Aceptar, todas las celdas donde los valores est\u00e9n duplicados en ambas columnas se resaltar\u00e1n con el formato que seleccion\u00f3. Pero si desea resaltar celdas \u00fanicas en ambas columnas, debe seleccionar \u00ab\u00danica\u00bb en la lista desplegable. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90472\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-selectionnez-unique-pour-mettre-en-evidence-les-valeurs-uniques.png\" sizes=\"auto, \" srcset=\"\" alt=\"seleccione-\u00fanico-para-resaltar-valores-\u00fanicos\" width=\"381\" height=\"156\"><\/figure>\n<\/div>\n<p> Y cuando haga clic en Aceptar, resaltar\u00e1 d\u00f3nde los valores son \u00fanicos mediante la comparaci\u00f3n en ambas columnas. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90473\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-valeurs-uniques-mises-en-avant.png\" sizes=\"auto, \" srcset=\"\" alt=\"valores individuales resaltados\" width=\"260\" height=\"311\"><\/figure>\n<\/div>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comparer-la-mise-en-forme-conditionnelle-des-colonnes.xlsx\" rel=\"nofollow\">Descargar<\/a><\/div>\n<div class=\"gb-container gb-container-6076ba72 gb-container-mt\"> <a class=\"gb-button gb-button-76e6a499 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/conceptos-basicos-de-excel\/\">Aprende los conceptos b\u00e1sicos de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-a9e9e206 gb-headline-text gb-headline-mt-heading\"> Obtenga m\u00e1s informaci\u00f3n sobre <a href=\"https:\/\/exceladvisor.org\/es\/formato-condicional\/\">el formato condicional<\/a> <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-790317cb gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-a9845ede\">\n<div class=\"gb-container gb-container-a9845ede\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/aplicar-formato-condicional\/\">Aplicar formato condicional a una tabla din\u00e1mica<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/retirar\/\">Eliminar formato condicional<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/celdas-vacias\/\">Aplicar formato condicional en celdas en blanco en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/otra-celda\/\">Aplicar formato condicional basado en otra celda<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/otra-columna\/\">Aplicar formato condicional basado en otra columna<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-ec8ff319\">\n<div class=\"gb-container gb-container-ec8ff319\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, el formato condicional es la forma m\u00e1s sencilla de comparar dos columnas. Con esto puedes comparar dos columnas de varias maneras. En este tutorial, aprenderemos varios m\u00e9todos para utilizar el formato condicional para la comparaci\u00f3n de columnas. Comparar dos columnas por fila Con este m\u00e9todo, puede comparar las dos celdas en cada fila [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-274","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo comparar dos columnas en excel?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/comparar-columnas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo comparar dos columnas en excel?\" \/>\n<meta property=\"og:description\" content=\"En Excel, el formato condicional es la forma m\u00e1s sencilla de comparar dos columnas. Con esto puedes comparar dos columnas de varias maneras. En este tutorial, aprenderemos varios m\u00e9todos para utilizar el formato condicional para la comparaci\u00f3n de columnas. Comparar dos columnas por fila Con este m\u00e9todo, puede comparar las dos celdas en cada fila [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/comparar-columnas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/comparar-columnas\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/comparar-columnas\/\",\"name\":\"\u00bfc\u00f3mo comparar dos columnas en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/comparar-columnas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/comparar-columnas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png\",\"datePublished\":\"2023-11-07T16:11:29+00:00\",\"dateModified\":\"2023-12-25T10:24:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/comparar-columnas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/comparar-columnas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/comparar-columnas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/comparar-columnas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo comparar dos columnas en excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo comparar dos columnas en excel?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo comparar dos columnas en excel?","og_description":"En Excel, el formato condicional es la forma m\u00e1s sencilla de comparar dos columnas. Con esto puedes comparar dos columnas de varias maneras. En este tutorial, aprenderemos varios m\u00e9todos para utilizar el formato condicional para la comparaci\u00f3n de columnas. Comparar dos columnas por fila Con este m\u00e9todo, puede comparar las dos celdas en cada fila [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:18+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/","url":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/","name":"\u00bfc\u00f3mo comparar dos columnas en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png","datePublished":"2023-11-07T16:11:29+00:00","dateModified":"2023-12-25T10:24:18+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/comparar-columnas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/comparar-columnas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo comparar dos columnas en excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=274"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/274\/revisions"}],"predecessor-version":[{"id":916,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/274\/revisions\/916"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}