{"id":299,"date":"2023-11-05T18:40:28","date_gmt":"2023-11-05T18:40:28","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/toda-la-columna\/"},"modified":"2023-12-25T10:33:05","modified_gmt":"2023-12-25T10:33:05","slug":"toda-la-columna","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/toda-la-columna\/","title":{"rendered":"Formato condicional de una columna en excel"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1741983781\"><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>Si desea aplicar formato condicional a una columna completa, seleccione la columna o fila completa antes de abrir la opci\u00f3n de formato condicional para aplicar. Este tutorial analizar\u00e1 una forma r\u00e1pida de hacer esto. Empecemos.<\/p>\n<p> En el siguiente ejemplo, tenemos una cantidad en la columna A y debemos aplicar formato condicional a toda la columna A, que resalta todos los n\u00fameros mayores que 1500. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90539\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-en-forme-conditionnelle-a-une-colonne-entiere.png\" sizes=\"auto, \" srcset=\"\" alt=\"formato-condicional-para-una-columna-completa\" width=\"423\" height=\"286\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Pasos para aplicar formato condicional a una columna completa<\/h2>\n<ol>\n<li> Primero, seleccione la columna completa con el m\u00e9todo abreviado de teclado (Ctrl + Espacio) o haga clic en el encabezado de la columna. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"2-seleccionar-columna completa\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionner-toute-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-select-the-entire-column\" width=\"451\" height=\"304\"><\/li>\n<li> A continuaci\u00f3n, vaya a la pesta\u00f1a Inicio &gt; Formato condicional &gt; Regla de resaltado de celda &gt; Mayor que. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"regla 3 celdas resaltadas mayores que\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-cellules-en-surbrillance-regle-superieure-a.png\" sizes=\"auto, \" srcset=\"\" alt=\"3-highlight-cells-rule-greater-than\" width=\"565\" height=\"285\"><\/li>\n<li> Ahora, en el cuadro de di\u00e1logo mayor que, ingrese 1500 en el cuadro de entrada \u00abFormato de celdas mayores que\u00bb y seleccione el formato que desea aplicar a las celdas cuyo valor sea mayor que 1500. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"4-ingrese-un-valor-mayor-que-en-el-cuadro\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-entrez-superieur-a-la-valeur-dans-la-case.png\" sizes=\"auto, \" srcset=\"\" alt=\"4-enter-greater-than-value-in-box\" width=\"530\" height=\"255\"><\/li>\n<li> Finalmente, haga clic en Aceptar para aplicar el formato a toda la columna. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"5-aplicar-formato-a-toda-la-columna\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-appliquer-le-formatage-a-toute-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"5-apply-formatting-to-entire-column\" width=\"452\" height=\"305\"><\/li>\n<\/ol>\n<p> Ahora aqu\u00ed el formato condicional se aplica a toda la columna, y cuando ingresa un nuevo valor al final, tambi\u00e9n verifica si la condici\u00f3n es que el valor sea mayor que 1500 o no. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90544\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-formatage-conditionnel-applique-a-toute-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"formato-condicional-aplicado-a-columna-completa\" width=\"308\" height=\"227\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Usar una tabla en lugar de una columna completa<\/h2>\n<p> No hay ning\u00fan problema cuando aplicas formato condicional a una columna completa, pero si usas una tabla de Excel (Ctrl + T para aplicar) puedes hacerla din\u00e1mica. Ampliar\u00e1 el formato condicional una vez que ingrese un nuevo valor. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90545\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-utiliser-le-tableau-au-lieu-de-la-colonne-entiere.png\" sizes=\"auto, \" srcset=\"\" alt=\"usar-la-tabla-en-lugar-de-la-columna-completa\" width=\"588\" height=\"444\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior, el formato condicional solo se aplica al rango A1:A100. Sin embargo, debido a que aplicamos la tabla de Excel a los datos cuando ingresa un nuevo valor para ampliar el rango de datos, esto tambi\u00e9n ampl\u00eda 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-90546\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-formatage-sapplique-a-la-plage-etendue.png\" sizes=\"auto, \" srcset=\"\" alt=\"el formato-se-aplica-al-rango-extendido\" width=\"300\" height=\"295\"><\/figure>\n<\/div>\n<p> Ambos m\u00e9todos funcionan muy bien; puedes elegir lo que se adapte a tus necesidades.<\/p>\n<h2 class=\"wp-block-heading\"> Aplicar formato condicional a toda la l\u00ednea.<\/h2>\n<p> Si desea aplicar formato condicional a toda la l\u00ednea, puede seguir los mismos pasos que utilizamos en el ejemplo anterior.<\/p>\n<p> Todos los pasos son iguales; primero debe seleccionar la fila completa y luego aplicarle formato condicional. Y para seleccionar una fila completa, haga clic en el encabezado de la fila o use el m\u00e9todo abreviado de teclado May\u00fas + Espacio. <\/p>\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\/11\/mise-en-forme-conditionnelle-de-toute-la-colonne.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\/comparar-columnas\/\">Compare dos columnas usando formato condicional<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/otra-celda\/\">Aplicar formato condicional basado en otra celda<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Si desea aplicar formato condicional a una columna completa, seleccione la columna o fila completa antes de abrir la opci\u00f3n de formato condicional para aplicar. Este tutorial analizar\u00e1 una forma r\u00e1pida de hacer esto. Empecemos. En el siguiente ejemplo, tenemos una cantidad en la columna A y debemos aplicar formato condicional a toda la columna [&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-299","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>Formato condicional de una columna 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\/toda-la-columna\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formato condicional de una columna en excel\" \/>\n<meta property=\"og:description\" content=\"Si desea aplicar formato condicional a una columna completa, seleccione la columna o fila completa antes de abrir la opci\u00f3n de formato condicional para aplicar. Este tutorial analizar\u00e1 una forma r\u00e1pida de hacer esto. Empecemos. En el siguiente ejemplo, tenemos una cantidad en la columna A y debemos aplicar formato condicional a toda la columna [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/toda-la-columna\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:33:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-en-forme-conditionnelle-a-une-colonne-entiere.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\/toda-la-columna\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/toda-la-columna\/\",\"name\":\"Formato condicional de una columna en excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/toda-la-columna\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/toda-la-columna\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-en-forme-conditionnelle-a-une-colonne-entiere.png\",\"datePublished\":\"2023-11-05T18:40:28+00:00\",\"dateModified\":\"2023-12-25T10:33:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/toda-la-columna\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/toda-la-columna\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/toda-la-columna\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-en-forme-conditionnelle-a-une-colonne-entiere.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-en-forme-conditionnelle-a-une-colonne-entiere.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/toda-la-columna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formato condicional de una columna 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":"Formato condicional de una columna 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\/toda-la-columna\/","og_locale":"es_ES","og_type":"article","og_title":"Formato condicional de una columna en excel","og_description":"Si desea aplicar formato condicional a una columna completa, seleccione la columna o fila completa antes de abrir la opci\u00f3n de formato condicional para aplicar. Este tutorial analizar\u00e1 una forma r\u00e1pida de hacer esto. Empecemos. En el siguiente ejemplo, tenemos una cantidad en la columna A y debemos aplicar formato condicional a toda la columna [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/toda-la-columna\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:33:05+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-en-forme-conditionnelle-a-une-colonne-entiere.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\/toda-la-columna\/","url":"https:\/\/exceladvisor.org\/es\/toda-la-columna\/","name":"Formato condicional de una columna en excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/toda-la-columna\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/toda-la-columna\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-en-forme-conditionnelle-a-une-colonne-entiere.png","datePublished":"2023-11-05T18:40:28+00:00","dateModified":"2023-12-25T10:33:05+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/toda-la-columna\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/toda-la-columna\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/toda-la-columna\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-en-forme-conditionnelle-a-une-colonne-entiere.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-en-forme-conditionnelle-a-une-colonne-entiere.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/toda-la-columna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"Formato condicional de una columna 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\/299","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=299"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/299\/revisions"}],"predecessor-version":[{"id":1456,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/299\/revisions\/1456"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}