{"id":25482,"date":"2025-04-21T12:30:00","date_gmt":"2025-04-21T17:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=25482"},"modified":"2025-04-21T11:02:18","modified_gmt":"2025-04-21T16:02:18","slug":"semaforos-en-excel-con-formato-condicional","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/","title":{"rendered":"Sem\u00e1foros en Excel con formato condicional"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-como-hacer-semaforos-en-excel-con-formato-condicional-3-ejemplos-practicos\">\ud83d\udfe2\ud83d\udfe1\ud83d\udd34 C\u00f3mo Hacer Sem\u00e1foros en Excel con Formato Condicional | 3 Ejemplos Pr\u00e1cticos<\/h1>\n\n\n\n<p>\u00bfQuieres resaltar informaci\u00f3n importante en tus hojas de c\u00e1lculo de manera visual y autom\u00e1tica? Los <strong>sem\u00e1foros en Excel con formato condicional<\/strong> son una herramienta ideal para lograrlo. Con solo unos clics puedes mostrar alertas visuales en color rojo, amarillo o verde que te ayudar\u00e1n a tomar decisiones r\u00e1pidamente. En este tutorial te ense\u00f1amos tres formas pr\u00e1cticas de aplicar esta t\u00e9cnica, usando n\u00fameros, fechas y columnas auxiliares. \u00a1Perfecto para estudiantes, emprendedores o cualquier persona que trabaje con Excel!<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"\ud83d\udfe2\ud83d\udfe1\ud83d\udd34 C\u00f3mo Hacer SEM\u00c1FOROS en Excel con Formato Condicional | \u00a13 Ejemplos PR\u00c1CTICOS!\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/vxJh7aXKxQY?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-c30f01\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-1f8456 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Semaforos-material-de-apoyo.zip\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 41.6\"><g><path d=\"M30.777 0a17.252 17.252 0 0 0-15.969 10.734 12.026 12.026 0 1 0-5.2 23.479 2.084 2.084 0 0 0 .413.042 2.051 2.051 0 0 0 .409-4.06 7.924 7.924 0 0 1 1.6-15.686 7.84 7.84 0 0 1 3.231.691l2.2.986.617-2.333a13.132 13.132 0 0 1 25.821 3.372 12.993 12.993 0 0 1-4.169 9.6 2.052 2.052 0 0 0 2.8 3A17.229 17.229 0 0 0 30.779.002\"><\/path><path d=\"M34.188 29.466h-5.18V15.578a1.164 1.164 0 0 0-1.164-1.164h-3.94a1.164 1.164 0 0 0-1.164 1.164v13.888h-5.18a1.164 1.164 0 0 0-.888 1.917l8.314 9.8a1.164 1.164 0 0 0 1.775 0l8.315-9.8a1.164 1.164 0 0 0-.888-1.917\"><\/path><\/g><\/svg><\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Primer ejemplo: Sem\u00e1foros en Excel para controlar inventario<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"f5f4f4\" data-has-transparency=\"true\" fetchpriority=\"high\" decoding=\"async\" width=\"651\" height=\"819\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-29-png.avif\" alt=\"&quot;alt&quot;= Uso de Conjuntos de Iconos en Formato Condicional de Excel\" class=\"wp-image-25486 has-transparency\" style=\"--dominant-color: #f5f4f4; width:373px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-29-png.avif 651w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-29-238x300.avif 238w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-29-600x755.avif 600w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/figure>\n\n\n\n<p>El primer caso es uno de los m\u00e1s comunes: <strong>usar sem\u00e1foros en Excel con formato condicional para controlar el stock de productos<\/strong>. <strong>En este sentido<\/strong>, se trata de una t\u00e9cnica muy visual y f\u00e1cil de aplicar. <strong>Adem\u00e1s<\/strong>, el proceso es sencillo:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Selecciona las celdas donde se encuentra el inventario.<\/li>\n\n\n\n<li>Ve a la pesta\u00f1a <strong>Inicio &gt; Formato condicional &gt; Conjunto de iconos<\/strong>.<\/li>\n\n\n\n<li>Elige los \u00edconos de sem\u00e1foro.<\/li>\n\n\n\n<li>Haz clic en <strong>M\u00e1s reglas<\/strong> para personalizar las condiciones.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-semaforos-en-excel-con-formato-condicional-configuracion-recomendada\">Sem\u00e1foros en Excel con formato condicional: Configuraci\u00f3n recomendada:<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"efefef\" data-has-transparency=\"true\" decoding=\"async\" width=\"699\" height=\"613\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-28-png.avif\" alt=\"&quot;alt&quot;=Configuraci\u00f3n de Regla de Formato Condicional con Iconos\" class=\"wp-image-25485 has-transparency\" style=\"--dominant-color: #efefef; width:384px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-28-png.avif 699w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-28-300x263.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-28-600x526.avif 600w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Verde<\/strong>: m\u00e1s de 100 unidades.<\/li>\n\n\n\n<li><strong>Amarillo<\/strong>: entre 100 y 50 unidades.<\/li>\n\n\n\n<li><strong>Rojo<\/strong>: menos de 50 unidades.<\/li>\n<\/ul>\n\n\n\n<p>Esto te permitir\u00e1 visualizar r\u00e1pidamente el estado de tu inventario sin necesidad de analizar cada n\u00famero.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Segundo ejemplo: Aplicar sem\u00e1foros con fechas de vencimiento<\/h2>\n\n\n\n<p>En este ejemplo, se usan <strong>sem\u00e1foros en Excel con formato condicional<\/strong> para alertar sobre productos que est\u00e1n pr\u00f3ximos a vencer. <strong>Para lograrlo<\/strong>, la clave est\u00e1 en utilizar la funci\u00f3n <code>=AHORA()<\/code>, la cual permite obtener autom\u00e1ticamente la fecha actual. <strong>De esta manera<\/strong>, puedes comparar esta fecha con la fecha de vencimiento de cada producto. <strong>As\u00ed<\/strong>, Excel resaltar\u00e1 visualmente con colores tipo sem\u00e1foro (verde, amarillo o rojo) seg\u00fan la proximidad del vencimiento. <strong>En resumen<\/strong>, esta t\u00e9cnica facilita la toma de decisiones r\u00e1pidas y efectivas en el control de inventarios.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-semaforos-en-excel-con-formato-condicional-pasos-para-configurar\">Sem\u00e1foros en Excel con formato condicional: Pasos para configurar:<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"efefef\" data-has-transparency=\"true\" decoding=\"async\" width=\"695\" height=\"614\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-30-png.avif\" alt=\"\" class=\"wp-image-25487 has-transparency\" style=\"--dominant-color: #efefef; width:507px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-30-png.avif 695w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-30-300x265.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-30-600x530.avif 600w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Selecciona la columna de fechas de vencimiento.<\/li>\n\n\n\n<li>Aplica el formato condicional con \u00edconos de sem\u00e1foro.<\/li>\n\n\n\n<li>Usa reglas como:\n<ul class=\"wp-block-list\">\n<li>Verde: m\u00e1s de 8 d\u00edas antes del vencimiento (<code>AHORA() + 8<\/code>).<\/li>\n\n\n\n<li>Amarillo: entre hoy y 8 d\u00edas.<\/li>\n\n\n\n<li>Rojo: vencidos (menores a <code>AHORA()<\/code>).<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p>Este m\u00e9todo es ideal para gestionar productos perecederos, tareas con fechas l\u00edmite o incluso proyectos con entregas programadas.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Tercer ejemplo: Comparaciones personalizadas con columna auxiliar<\/h2>\n\n\n\n<p>A veces necesitas comparar el stock actual con diferentes valores recomendados por producto. Por ejemplo, no es igual el m\u00ednimo de camisetas que el de zapatos. Como Excel no permite hacer comparaciones directas entre columnas usando \u00edconos, se usa una <strong>columna auxiliar<\/strong> para representar los estados.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-semaforos-en-excel-con-formato-condicional-como-hacerlo\">Sem\u00e1foros en Excel con formato condicional: C\u00f3mo hacerlo:<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"ebebea\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"435\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-31-png.avif\" alt=\"\" class=\"wp-image-25488 has-transparency\" style=\"--dominant-color: #ebebea; width:751px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-31-png.avif 975w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-31-300x134.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-31-768x343.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/image-31-600x268.avif 600w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Crea una columna auxiliar con la funci\u00f3n <code>SI.CONJUNTO<\/code>: excelCopiarEditar<code>=SI.CONJUNTO( [StockActual] &gt; [StockM\u00ednimo], 3, [StockActual] = [StockM\u00ednimo], 2, [StockActual] &lt; [StockM\u00ednimo], 1 )<\/code><\/li>\n\n\n\n<li>Aplica el formato condicional en esta nueva columna.<\/li>\n\n\n\n<li>Configura los iconos:\n<ul class=\"wp-block-list\">\n<li>3 = verde<\/li>\n\n\n\n<li>2 = amarillo<\/li>\n\n\n\n<li>1 = rojo<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Oculta los n\u00fameros y deja solo los iconos visibles.<\/li>\n<\/ol>\n\n\n\n<p>Este m\u00e9todo es m\u00e1s flexible y permite comparar cada producto seg\u00fan sus propias reglas.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Ventajas de usar sem\u00e1foros en Excel con formato condicional<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Visualizaci\u00f3n r\u00e1pida del estado de tus datos.<\/li>\n\n\n\n<li>Ahorro de tiempo en an\u00e1lisis y revisi\u00f3n.<\/li>\n\n\n\n<li>Personalizaci\u00f3n seg\u00fan tus propias condiciones.<\/li>\n\n\n\n<li>Compatible con todas las versiones de Excel.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfNo tienes Office original?<\/h2>\n\n\n\n<p>Si a\u00fan no cuentas con una versi\u00f3n original de Excel, puedes comprar licencias vitalicias a bajo costo en <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a><\/strong>. Solo debes usar el cup\u00f3n <strong>DH66<\/strong> para obtener un <strong>66% de descuento<\/strong>. As\u00ed puedes acceder a todas las funciones, incluyendo el formato condicional avanzado.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u00a1\ud83d\udea8 No te quedes atr\u00e1s en el mundo laboral! Dominar Excel ya no es opcional, es una necesidad \ud83d\udcca. Si quieres destacar, ahorrar tiempo y trabajar de forma m\u00e1s eficiente, te recomendamos inscribirte en un <strong>curso de Excel completo y pr\u00e1ctico<\/strong> \ud83d\udca1. Aprender\u00e1s desde lo b\u00e1sico hasta funciones avanzadas, con ejemplos reales y explicaciones f\u00e1ciles de seguir \u2705. \u00a1Invierte en ti y lleva tus habilidades al siguiente nivel! \ud83d\ude80<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Los <strong>sem\u00e1foros en Excel con formato condicional<\/strong> son una herramienta visual poderosa y muy f\u00e1cil de usar. Ya sea para controlar inventarios, fechas de vencimiento o comparar condiciones espec\u00edficas, estos indicadores te permiten tomar decisiones m\u00e1s r\u00e1pidas y eficientes. \u00a1An\u00edmate a probar estos tres ejemplos pr\u00e1cticos y transforma tus hojas de c\u00e1lculo!<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Preguntas frecuentes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-c3509f83 uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-30e9de82 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfQu\u00e9 versiones de Excel soportan los sem\u00e1foros con formato condicional?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Todas las versiones desde Excel 2007 en adelante soportan esta funci\u00f3n.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-caf2edca \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPuedo usar sem\u00e1foros con texto?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>No directamente. Los \u00edconos funcionan mejor con valores num\u00e9ricos.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-4eab1d53 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfSe puede comparar valores entre columnas sin usar una columna auxiliar?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>No, actualmente Excel no permite esa funcionalidad con conjuntos de iconos.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-8599c118 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfD\u00f3nde puedo conseguir plantillas con estos ejemplos?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes descargar el archivo de pr\u00e1ctica desde la <strong>descripci\u00f3n del video en YouTube<\/strong> o en el <strong>primer comentario fijado<\/strong>.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-fb9a82b2 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPuedo cambiar los \u00edconos de los sem\u00e1foros por otros s\u00edmbolos?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, Excel permite personalizar los conjuntos de iconos. Puedes elegir entre diferentes estilos como flechas, c\u00edrculos, barras o crear un formato condicional con s\u00edmbolos personalizados usando emojis o caracteres especiales combinados con reglas de formato.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>\ud83d\udfe2\ud83d\udfe1\ud83d\udd34 C\u00f3mo Hacer Sem\u00e1foros en Excel con Formato Condicional | 3 Ejemplos Pr\u00e1cticos \u00bfQuieres resaltar informaci\u00f3n importante en tus hojas [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":25483,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[52],"tags":[225,232,247,539,486],"class_list":["post-25482","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriales-excel","tag-excel","tag-facil","tag-formato-condicional","tag-gratuito","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Sem\u00e1foros en Excel con formato condicional - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Crea sem\u00e1foros en Excel con formato condicional para controlar inventario, fechas y m\u00e1s con ejemplos f\u00e1ciles y visuales.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sem\u00e1foros en Excel con formato condicional para inventario\" \/>\n<meta property=\"og:description\" content=\"Aprende a implementar sem\u00e1foros en Excel con formato condicional para facilitar la toma de decisiones en tus hojas de c\u00e1lculo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-21T17:30:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"750\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Sem\u00e1foros en Excel con formato condicional f\u00e1ciles\" \/>\n<meta name=\"twitter:description\" content=\"Aprende a aplicar sem\u00e1foros en Excel con formato condicional. Haz tus hojas de c\u00e1lculo m\u00e1s efectivas y visuales.\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Sem\u00e1foros en Excel con formato condicional\",\"datePublished\":\"2025-04-21T17:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/\"},\"wordCount\":789,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/Control-de-tareas-miniatura-04.avif\",\"keywords\":[\"Excel\",\"Facil\",\"Formato Condicional\",\"Gratuito\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/\",\"name\":\"Sem\u00e1foros en Excel con formato condicional - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/Control-de-tareas-miniatura-04.avif\",\"datePublished\":\"2025-04-21T17:30:00+00:00\",\"description\":\"Crea sem\u00e1foros en Excel con formato condicional para controlar inventario, fechas y m\u00e1s con ejemplos f\u00e1ciles y visuales.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/Control-de-tareas-miniatura-04.avif\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/Control-de-tareas-miniatura-04.avif\",\"width\":1000,\"height\":750},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/semaforos-en-excel-con-formato-condicional\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sem\u00e1foros en Excel con formato condicional\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780322344\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780322344\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780322344\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sem\u00e1foros en Excel con formato condicional - Dostin Hurtado","description":"Crea sem\u00e1foros en Excel con formato condicional para controlar inventario, fechas y m\u00e1s con ejemplos f\u00e1ciles y visuales.","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:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/","og_locale":"es_ES","og_type":"article","og_title":"Sem\u00e1foros en Excel con formato condicional para inventario","og_description":"Aprende a implementar sem\u00e1foros en Excel con formato condicional para facilitar la toma de decisiones en tus hojas de c\u00e1lculo.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/","og_site_name":"Dostin Hurtado","article_published_time":"2025-04-21T17:30:00+00:00","og_image":[{"width":1000,"height":750,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"Sem\u00e1foros en Excel con formato condicional f\u00e1ciles","twitter_description":"Aprende a aplicar sem\u00e1foros en Excel con formato condicional. Haz tus hojas de c\u00e1lculo m\u00e1s efectivas y visuales.","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Sem\u00e1foros en Excel con formato condicional","datePublished":"2025-04-21T17:30:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/"},"wordCount":789,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif","keywords":["Excel","Facil","Formato Condicional","Gratuito","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/","name":"Sem\u00e1foros en Excel con formato condicional - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif","datePublished":"2025-04-21T17:30:00+00:00","description":"Crea sem\u00e1foros en Excel con formato condicional para controlar inventario, fechas y m\u00e1s con ejemplos f\u00e1ciles y visuales.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif","width":1000,"height":750},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/semaforos-en-excel-con-formato-condicional\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Sem\u00e1foros en Excel con formato condicional"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780322344","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780322344","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780322344","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif",1000,750,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04-768x576.avif",768,576,true],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif",1000,750,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif",1000,750,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif",1000,750,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04.avif",1000,750,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04-870x570.avif",870,570,true],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04-600x750.avif",600,750,true],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04-600x600.avif",600,600,true],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04-400x400.avif",400,400,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04-600x450.avif",600,450,true],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/Control-de-tareas-miniatura-04-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":0,"uagb_excerpt":"\ud83d\udfe2\ud83d\udfe1\ud83d\udd34 C\u00f3mo Hacer Sem\u00e1foros en Excel con Formato Condicional | 3 Ejemplos Pr\u00e1cticos \u00bfQuieres resaltar informaci\u00f3n importante en tus hojas [&hellip;]","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/25482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=25482"}],"version-history":[{"count":3,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/25482\/revisions"}],"predecessor-version":[{"id":25499,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/25482\/revisions\/25499"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/25483"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=25482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=25482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=25482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}