{"id":1746,"date":"2023-11-07T16:11:29","date_gmt":"2023-11-07T16:11:29","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/"},"modified":"2023-12-10T06:21:57","modified_gmt":"2023-12-10T06:21:57","slug":"confrontare-le-colonne","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/","title":{"rendered":"Come confrontare due colonne in excel?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-2065709020\"><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>In Excel, la formattazione condizionale \u00e8 il modo pi\u00f9 semplice per confrontare due colonne. Con questo puoi confrontare due colonne in diversi modi. In questo tutorial impareremo diversi metodi per utilizzare la formattazione condizionale per il confronto delle colonne.<\/p><h2 class=\"wp-block-heading\"> Confronta due colonne per riga<\/h2><p> Con questo metodo puoi confrontare le due celle in ciascuna riga delle colonne ed evidenziare le celle con lo stesso valore.<\/p><ol><li> Innanzitutto, seleziona entrambe le colonne nei dati. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-seleziona-entrambe-le-colonne\" 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><li> Successivamente, vai alla scheda Home &gt; Formattazione condizionale &gt; Nuova regola. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-formattazione-condizionale-nuova-regola\" 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><li> Da l\u00ec, fai clic su \u201cUtilizza una formula per determinare quali celle formattare\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-seleziona-usa-una-formula-per-determinare\" 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><li> Successivamente, nella barra della formula, inserisci la formula =$A2&lt;&gt;$B2, quindi fai clic su &#8220;Formato&#8230;&#8221; per specificare il formato. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-inserisci-la-formula-e-specifica-il-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><li> Una volta specificato il formato, fare clic su OK per applicare la formattazione condizionale e di nuovo su OK per chiudere Gestione regole. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-chiudi-le-regole-manager\" 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><\/ol><p> E nel momento in cui fai clic su OK, vengono evidenziate le celle in entrambe le colonne in cui i valori sono gli stessi. <\/p><div class=\"wp-block-image\"><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=\"celle evidenziate con gli stessi valori\" width=\"280\" height=\"331\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Confronta tutti i valori in tutte le colonne<\/h2><p> A differenza del primo metodo, puoi evidenziare entrambi i valori che sono duplicati nelle colonne. E per questo, seleziona entrambe le colonne e vai alla scheda Home &gt; Formattazione condizionale &gt; Regole di evidenziazione delle celle &gt; Valori duplicati. <\/p><div class=\"wp-block-image\"><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=\"seleziona valori duplicati\" width=\"530\" height=\"440\"><\/figure><\/div><p> Nella finestra di dialogo Valori duplicati, seleziona i valori che desideri evidenziare e il colore che desideri applicare. <\/p><div class=\"wp-block-image\"><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=\"seleziona-duplicato-per-evidenziare-duplicati\" width=\"388\" height=\"160\"><\/figure><\/div><p> Alla fine, fai clic su OK per applicare la formattazione condizionale. <\/p><div class=\"wp-block-image\"><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=\"evidenziato valori duplicati\" width=\"285\" height=\"324\"><\/figure><\/div><p> Nel momento in cui fai clic su OK, tutte le celle in cui i valori sono duplicati in entrambe le colonne verranno evidenziate con il formato selezionato. Ma se desideri evidenziare celle univoche in entrambe le colonne, devi selezionare &#8220;Singola&#8221; dall&#8217;elenco a discesa. <\/p><div class=\"wp-block-image\"><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=\"seleziona-univoco-per-evidenziare-valori-unici\" width=\"381\" height=\"156\"><\/figure><\/div><p> E quando fai clic su OK, verr\u00e0 evidenziato dove i valori sono univoci utilizzando il confronto in entrambe le colonne. <\/p><div class=\"wp-block-image\"><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=\"singoli valori evidenziati\" width=\"260\" height=\"311\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Ottieni il file Excel<\/h2> <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\">Scaricamento<\/a><\/div><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\/it\/nozioni-di-base-su-excel\/\">Impara le basi di Excel<\/a><h2 class=\"gb-headline gb-headline-a9e9e206 gb-headline-text gb-headline-mt-heading\"> Ulteriori informazioni sulla <a href=\"https:\/\/exceladvisor.org\/it\/formattazione-condizionale\/\">formattazione condizionale<\/a> <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-790317cb gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-a9845ede\"><div class=\"gb-container gb-container-a9845ede\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/it\/applicare-la-formattazione-condizionale\/\">Applicare la formattazione condizionale a una tabella pivot<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/ritirare\/\">Rimuovi la formattazione condizionale<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/celle-vuote\/\">Applica la formattazione condizionale su celle vuote in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/unaltra-cella\/\">Applica la formattazione condizionale in base a un&#8217;altra cella<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/unaltra-colonna\/\">Applica la formattazione condizionale in base a un&#8217;altra colonna<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-ec8ff319\"><div class=\"gb-container gb-container-ec8ff319\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","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-1746","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>Come confrontare due colonne in Excel? [Guida 2023]<\/title>\n<meta name=\"description\" content=\"Questo tutorial ti aiuta a confrontare due colonne utilizzando la formattazione condizionale in Excel. Controlliamo questo...\" \/>\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\/it\/confrontare-le-colonne\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come confrontare due colonne in Excel? [Guida 2023]\" \/>\n<meta property=\"og:description\" content=\"Questo tutorial ti aiuta a confrontare due colonne utilizzando la formattazione condizionale in Excel. Controlliamo questo...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:21:57+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=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/\",\"name\":\"Come confrontare due colonne in Excel? [Guida 2023]\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/#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-10T06:21:57+00:00\",\"description\":\"Questo tutorial ti aiuta a confrontare due colonne utilizzando la formattazione condizionale in Excel. Controlliamo questo...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/#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\/it\/confrontare-le-colonne\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come confrontare due colonne in excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come confrontare due colonne in Excel? [Guida 2023]","description":"Questo tutorial ti aiuta a confrontare due colonne utilizzando la formattazione condizionale in Excel. Controlliamo questo...","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\/it\/confrontare-le-colonne\/","og_locale":"it_IT","og_type":"article","og_title":"Come confrontare due colonne in Excel? [Guida 2023]","og_description":"Questo tutorial ti aiuta a confrontare due colonne utilizzando la formattazione condizionale in Excel. Controlliamo questo...","og_url":"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:21:57+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":{"Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/","url":"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/","name":"Come confrontare due colonne in Excel? [Guida 2023]","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/#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-10T06:21:57+00:00","description":"Questo tutorial ti aiuta a confrontare due colonne utilizzando la formattazione condizionale in Excel. Controlliamo questo...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/confrontare-le-colonne\/#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\/it\/confrontare-le-colonne\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come confrontare due colonne in excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1746","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=1746"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1746\/revisions"}],"predecessor-version":[{"id":2389,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1746\/revisions\/2389"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=1746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}