{"id":18136,"date":"2022-02-25T08:50:00","date_gmt":"2022-02-25T13:50:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=18136"},"modified":"2026-01-13T10:43:47","modified_gmt":"2026-01-13T15:43:47","slug":"formato-condicional","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/","title":{"rendered":"Formato condicional"},"content":{"rendered":"<h2>FORMATO CONDICIONAL<\/h2>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Nuevo Curso de Excel - Cap\u00edtulo 8, Formato Condicional \ud83c\udf93 Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/ZCNJOailkzU?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><\/div>\n<h2>DESCRIPCI\u00d3N<\/h2>\n<p>El formato condicional es una herramienta que nos servir\u00e1 para poder identificar datos de manera autom\u00e1tica modificando la apariencia de la celda, as\u00ed podr\u00e1n hacer que una celda cambie de color o agregue un signo de manera autom\u00e1tica seg\u00fan su contenido, esto es muy f\u00e1cil y les voy a ense\u00f1ar las diferentes maneras de realizarlo, siempre recomiendo hacerlo de manera manual para poder ajustar adecuadamente las reglas del formato.<\/p>\n<p>No olvides ver el v\u00eddeo completo, te ense\u00f1o diferentes maneras de realizar el formato condicional seg\u00fan el contenido de la celda, recuerda que si te ha gustado este cap\u00edtulo le puedes dar me gusta, comentar si tienes alguna duda y compartirlo a quien crean que le puede servir.<\/p>\n<p>Al final les he dejado una tarea donde podr\u00e1n poner a prueba todo el conocimiento que les he ense\u00f1ado, lo ideal es que la resuelvan ustedes mismo, pero si se les dificulta les he dejado aqu\u00ed mismo la soluci\u00f3n a la tarea.<\/p>\n<h5 style=\"text-align: center;\"><strong>DESCARGAR MATERIAL DE APOYO<\/strong><\/h5>\n<p><a href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/05\/Capitulo_8_Excel.xlsx\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_directa.png\" alt=\"\" width=\"185\" height=\"47\" \/><\/a><\/p>\n<h2>TAREA RESUELTA<\/h2>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Nuevo Curso de Excel - Cap\u00edtulo 8, Tarea \ud83c\udf93 Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/BP6xyazKCbQ?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><\/div>\n<h2>DESCRIPCI\u00d3N<\/h2>\n<p>\u00a1Hola, muchachos! Con este v\u00eddeo voy a darle respuesta a la tarea que les he dejado en el cap\u00edtulo n\u00famero 8 del nuevo curso de Excel, vamos a usar 3 ejercicios y un reto para repasar lo ya visto en el cap\u00edtulo, recuerden que primero deben intentar resolver estos ejercicios por su propia cuenta y si ya no lo lograron viene a ver este v\u00eddeo.<\/p>\n<h5 style=\"text-align: center;\"><strong>DESCARGAR TAREA<\/strong><\/h5>\n<p><a href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/05\/Capitulo_8_Excel_Tarea.xlsx\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_directa.png\" alt=\"\" width=\"185\" height=\"47\" \/><\/a><\/p>\n<p><a role=\"button\" href=\"https:\/\/dostinhurtado.com\/site\/cursos\/excel-curso-basico-intermedio\/llamado-de-datos\/\"><br \/>\nCAP\u00cdTULO ANTERIOR<br \/>\n<\/a><br \/>\n<a role=\"button\" href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/excel-curso-basico-intermedio\/\"><br \/>\nLISTA DE CAP\u00cdTULOS<br \/>\n<\/a><br \/>\n<a role=\"button\" href=\"https:\/\/dostinhurtado.com\/site\/cursos\/excel-curso-basico-intermedio\/validacion-de-datos\/\"><br \/>\nCAP\u00cdTULO SIGUIENTE<br \/>\n<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>El formato condicional es una herramienta que nos servir\u00e1 para poder identificar datos de manera autom\u00e1tica modificando la apariencia de la celda, as\u00ed podr\u00e1n hacer que una celda cambie de color o agregue un signo de manera autom\u00e1tica seg\u00fan su contenido, esto es muy f\u00e1cil y les voy a ense\u00f1ar las diferentes maneras de realizarlo, siempre recomiendo hacerlo de manera manual para poder ajustar adecuadamente las reglas del formato.<\/p>\n","protected":false},"author":4,"featured_media":27278,"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":[1714],"tags":[1805,1892,147,562,225,232,247,277,539,1769,570,486],"class_list":["post-18136","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-curso-basico-intermedio","tag-1805","tag-aprende-excel","tag-celdas","tag-curso","tag-excel","tag-facil","tag-formato-condicional","tag-gratis","tag-gratuito","tag-nuevo-curso","tag-recomendado","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Formato condicional - Dostin Hurtado<\/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:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formato condicional - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"El formato condicional es una herramienta que nos servir\u00e1 para poder identificar datos de manera autom\u00e1tica modificando la apariencia de la celda, as\u00ed podr\u00e1n hacer que una celda cambie de color o agregue un signo de manera autom\u00e1tica seg\u00fan su contenido, esto es muy f\u00e1cil y les voy a ense\u00f1ar las diferentes maneras de realizarlo, siempre recomiendo hacerlo de manera manual para poder ajustar adecuadamente las reglas del formato.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-25T13:50:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-13T15:43:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\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: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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Formato condicional\",\"datePublished\":\"2022-02-25T13:50:00+00:00\",\"dateModified\":\"2026-01-13T15:43:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/\"},\"wordCount\":275,\"commentCount\":8,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif\",\"keywords\":[\"2022\",\"aprende excel\",\"Celdas\",\"Curso\",\"Excel\",\"Facil\",\"Formato Condicional\",\"Gratis\",\"Gratuito\",\"nuevo curso\",\"recomendado\",\"Tutorial\"],\"articleSection\":[\"Nuevo Curso de Excel B\u00e1sico e Intermedio\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/\",\"name\":\"Formato condicional - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif\",\"datePublished\":\"2022-02-25T13:50:00+00:00\",\"dateModified\":\"2026-01-13T15:43:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif\",\"width\":500,\"height\":375,\"caption\":\"Formato condicional en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/formato-condicional\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"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=1780927217\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formato condicional - Dostin Hurtado","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\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/","og_locale":"es_ES","og_type":"article","og_title":"Formato condicional - Dostin Hurtado","og_description":"El formato condicional es una herramienta que nos servir\u00e1 para poder identificar datos de manera autom\u00e1tica modificando la apariencia de la celda, as\u00ed podr\u00e1n hacer que una celda cambie de color o agregue un signo de manera autom\u00e1tica seg\u00fan su contenido, esto es muy f\u00e1cil y les voy a ense\u00f1ar las diferentes maneras de realizarlo, siempre recomiendo hacerlo de manera manual para poder ajustar adecuadamente las reglas del formato.","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/","og_site_name":"Dostin Hurtado","article_published_time":"2022-02-25T13:50:00+00:00","article_modified_time":"2026-01-13T15:43:47+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Formato condicional","datePublished":"2022-02-25T13:50:00+00:00","dateModified":"2026-01-13T15:43:47+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/"},"wordCount":275,"commentCount":8,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif","keywords":["2022","aprende excel","Celdas","Curso","Excel","Facil","Formato Condicional","Gratis","Gratuito","nuevo curso","recomendado","Tutorial"],"articleSection":["Nuevo Curso de Excel B\u00e1sico e Intermedio"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/","name":"Formato condicional - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif","datePublished":"2022-02-25T13:50:00+00:00","dateModified":"2026-01-13T15:43:47+00:00","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif","width":500,"height":375,"caption":"Formato condicional en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"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=1780927217","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8-400x375.avif",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8.avif",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-8-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":8,"uagb_excerpt":"El formato condicional es una herramienta que nos servir\u00e1 para poder identificar datos de manera autom\u00e1tica modificando la apariencia de la celda, as\u00ed podr\u00e1n hacer que una celda cambie de color o agregue un signo de manera autom\u00e1tica seg\u00fan su contenido, esto es muy f\u00e1cil y les voy a ense\u00f1ar las diferentes maneras de realizarlo,&hellip;","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/18136","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=18136"}],"version-history":[{"count":2,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/18136\/revisions"}],"predecessor-version":[{"id":27291,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/18136\/revisions\/27291"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/27278"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=18136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=18136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=18136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}