{"id":16824,"date":"2014-07-04T17:30:29","date_gmt":"2014-07-04T23:30:29","guid":{"rendered":"http:\/\/aplicaexcelcontable.com\/blog\/?p=16824"},"modified":"2024-02-01T13:42:53","modified_gmt":"2024-02-01T19:42:53","slug":"5-consejos-para-aplicar-formato-condicional-en-excel-1","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/5-consejos-para-aplicar-formato-condicional-en-excel-1.html","title":{"rendered":"5 Consejos para Aplicar Formato Condicional en Excel-1"},"content":{"rendered":"<h1 style=\"text-align: center;\">Creaci\u00f3n de un plan de proyecto en Diagrama de gantt utilizando el formato condicional en Excel<\/h1>\n<p style=\"text-align: justify;\">En el articulo anterior, te comparti el Consejo numero uno Aplicar Formato Condicional en Excel, lograste verlo? Si aun no lo has visto <span style=\"color: #ff0000;\"><strong><a title=\"Resaltar Filas y Columnas Alternativas en Tablas Excel\" href=\"https:\/\/aplicaexcelcontable.com\/blog\/5-consejos-para-aplicar-formato-condicional-en-excel.html\" rel=\"noopener\"><span style=\"color: #ff0000;\">haz clic aqu\u00ed<\/span><\/a><\/strong><\/span>. Una vez termines de leer y aplicar el consejo numero 1, regrasa nuevamente a qui y continua con el Consejo numero 2.<\/p>\n<p style=\"text-align: justify;\">Si as\u00ed es, hoy voy a Compartirte el Consejo numero 2 y se trata de Como Crear un Plan de Proyecto en Diagrama de Gantt, utilizando formato Condicional Excel y Formulas Excel. Comencemos:<\/p>\n<h2 style=\"text-align: center;\">2 Creaci\u00f3n de un plan de proyecto en Diagrama de gantt utilizando el formato condicional en Excel<\/h2>\n<p><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Diagrama-de-Gantt-Formato-Condicional.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16827 size-full\" title=\"Excel, Formato Condicional, Aprender Excel, Formulas Excel\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Diagrama-de-Gantt-Formato-Condicional.png\" alt=\"Diagrama de Gantt - Formato Condicional\" width=\"504\" height=\"244\" srcset=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Diagrama-de-Gantt-Formato-Condicional.png 504w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Diagrama-de-Gantt-Formato-Condicional-300x145.png 300w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Las Tablas de planes de proyecto Gantt, son la actividad cotidiana de la mayor parte de nuestras vidas. La \u00a0Creaci\u00f3n de una plantilla de plan de proyecto simple y elegante en Excel no es un trabajo dif\u00edcil, utilizando el formato condicional con \u00a0un poco de f\u00f3rmulas Excel puedes crear Tu Plan de Proyecto. Entonces veamos como se hace:<\/p>\n<ul>\n<li style=\"text-align: justify;\">En primer lugar crear una estructura de tabla como se muestra m\u00e1s arriba, con las columnas como Actividad, Inicio y Fin del d\u00eda, el d\u00eda 1, 2,3, etc &#8230;<\/li>\n<li style=\"text-align: justify;\">Ahora, cada vez que un d\u00eda cae entre el inicio y el d\u00eda final para una actividad correspondiente, es necesario seleccionar esa fila.\u00a0Para eso necesitamos identificar si un d\u00eda cae entre el inicio y el final. Lo Podemos hacer \u00a0con las siguientes f\u00f3rmulas,\u00a0= SI (Y (F $ 8&gt; = $ D9, F $ 8 &lt;= $ E9), \u00ab1\u00bb, \u00ab\u00bb)\u00a0que significa, siempre, el n\u00famero de d\u00edas representados en la fila superior es entre el inicio y el final lo haremos en 1 en la celda correspondiente.<\/li>\n<li style=\"text-align: justify;\">A continuaci\u00f3n, cada vez que el valor de la celda es de 1, nos limitaremos a llenar la celda con un color favorito y cambiar el tipo de letra para el mismo color, de modo que nosotros no veamos otra cosa que una celda resaltada, mejor a\u00fan, cada vez que cambie el inicio o fechas de finalizaci\u00f3n, el color cambiar\u00e1 autom\u00e1ticamente.\u00a0Esto se har\u00e1 mediante el formato condicional, como a continuaci\u00f3n:<\/li>\n<\/ul>\n<p><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Formato-Condicional-Diagrama-de-Gatt.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16828 size-full\" title=\"Excel, Formato Condicional, Aprender Excel, Formulas Excel\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Formato-Condicional-Diagrama-de-Gatt.png\" alt=\"Formato Condicional - Diagrama de Gatt\" width=\"552\" height=\"372\" srcset=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Formato-Condicional-Diagrama-de-Gatt.png 552w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Formato-Condicional-Diagrama-de-Gatt-300x202.png 300w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><\/a><\/p>\n<ul>\n<li><strong>Enhorabuena, has dominado el arte de creaci\u00f3n de diagramas de Gantt en Excel.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">A continuacion te dejo el Libro Donde podras comprobar el Ejemplo de Cada uno de los consejos que te iremos compartiendo:<\/p>\n<p style=\"text-align: justify;\">Si te gusto el Contenido, compartelo con tus amigos de Facebook, pulsando clic en Me Gusta o Compartir:<\/p>\n<p>Te Saluda,<\/p>\n<p><strong>Roger Perez &#8211; Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creaci\u00f3n de un plan de proyecto en Diagrama de gantt utilizando el formato condicional en Excel En el articulo anterior, te comparti el Consejo numero uno Aplicar Formato Condicional en Excel, lograste verlo? Si aun no lo has visto haz clic aqu\u00ed. Una vez termines de leer y aplicar el consejo numero 1, regrasa nuevamente [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18d66227fda\" style=\"\"><h1 data-css=\"tve-u-18d66223fd0\" style=\"text-align: center;\" class=\"\">Creaci\u00f3n de un plan de proyecto en Diagrama de Gantt utilizando el formato condicional en Excel<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d6623337c\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d66233365\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">En el articulo anterior, te compart\u00ed el consejo numero uno Aplicar Formato Condicional en Excel, lograste verlo? Si aun no lo has visto <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/5-consejos-para-aplicar-formato-condicional-en-excel.html\" class=\"\" style=\"outline: none;\">pulsa clic aqu\u00ed<\/a>. Una vez termines de leer y aplicar el consejo numero 1, regresa nuevamente a qui y continua con el consejo numero 2.<\/p><p style=\"\">Si as\u00ed es, hoy voy a compartirte el consejo numero 2 y se trata de como crear un plan de proyecto en Diagrama de Gantt, utilizando formato condicional Excel y Formulas Excel. Bien comencemos entonces:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18d66227fda\" style=\"\"><h2 style=\"text-align: center;\" class=\"\" data-css=\"tve-u-18d66274053\">2. Creaci\u00f3n de un Plan de un Plan de Proyecto en Diagrama de Gantt utilizando el formato condicional en Excel<\/h2><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18d662914f7\"><span class=\"tve_image_frame\"><img class=\"tve_image wp-image-58303\" alt=\"\" data-id=\"58303\" width=\"504\" data-init-width=\"504\" height=\"244\" data-init-height=\"244\" title=\"Diagrama de Gantt Formato Condicional\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/02\/Diagrama-de-Gantt-Formato-Condicional.png\" data-width=\"504\" data-height=\"244\" style=\"aspect-ratio: auto 504 \/ 244;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d66296517\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d66296505\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Las Tablas de planes de proyecto Gantt, son la actividad cotidiana de la mayor parte de nuestras vidas. La &nbsp;creaci\u00f3n de una plantilla de plan de proyecto simple y elegante en Excel no es un trabajo dif\u00edcil, utilizando el formato condicional con &nbsp;un poco de f\u00f3rmulas Excel puedes crear tu plan de proyecto. Entonces veamos como se hace:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-18d662cb83b\"><div style=\"text-align: justify;\">En primer lugar crear una estructura de tabla como se muestra m\u00e1s arriba, con las columnas como Actividad, Inicio y Fin del d\u00eda, el d\u00eda 1, 2,3, etc.<\/div><\/span><\/li><li class=\"thrv-styled-list-item\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-18d662cb83b\"><div style=\"text-align: justify;\">Ahora, cada vez que un d\u00eda cae entre el inicio y el d\u00eda final para una actividad correspondiente, es necesario seleccionar esa fila. Para eso necesitamos identificar si un d\u00eda cae entre el inicio y el final. Lo Podemos hacer con las siguientes f\u00f3rmulas, = SI (Y (F $ 8&gt; = $ D9, F $ 8 &lt;= $ E9), \u00ab1\u00bb, \u00ab\u00bb) que significa, siempre, el n\u00famero de d\u00edas representados en la fila superior es entre el inicio y el final lo haremos en 1 en la celda correspondiente.<\/div><\/span><\/li><li class=\"thrv-styled-list-item\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-18d662cb83b\"><div style=\"text-align: justify;\">A continuaci\u00f3n, cada vez que el valor de la celda es de 1, nos limitaremos a llenar la celda con un color favorito y cambiar el tipo de letra para el mismo color, de modo que nosotros no veamos otra cosa que una celda resaltada, mejor a\u00fan, cada vez que cambie el inicio o fechas de finalizaci\u00f3n, el color cambiar\u00e1 autom\u00e1ticamente. Esto se har\u00e1 mediante el formato condicional, como a continuaci\u00f3n:<\/div><\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18d662f3b7f\"><span class=\"tve_image_frame\"><img class=\"tve_image wp-image-58305 tcb-moved-image\" alt=\"\" data-id=\"58305\" width=\"552\" data-init-width=\"552\" height=\"372\" data-init-height=\"372\" title=\"Formato Condicional Diagrama de Gatt\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/02\/Formato-Condicional-Diagrama-de-Gatt.png\" data-width=\"552\" data-height=\"372\" style=\"aspect-ratio: auto 552 \/ 372;\" data-css=\"tve-u-18d662f479b\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d6630328e\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d6630327a\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Enhorabuena, has dominado el arte de creaci\u00f3n de diagramas de Gantt en Excel. A continuaci\u00f3n te dejo el Libro Donde podr\u00e1s comprobar el Ejemplo de Cada uno de los consejos que te iremos compartiendo:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16d97954e90\"><div class=\"tve-content-box-background\" data-css=\"tve-u-16d97954e96\" data-clip-id=\"b88a515ccdde\"><svg width=\"0\" height=\"0\" class=\"tve-decoration-svg\"><defs><clipPath id=\"clip-top-b88a515ccdde\" class=\"decoration-clip clip-path-top\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"none\" pointer-width=\"5\" pointer-height=\"5\" style=\"zigzag\" clip-path=\"url(#clip-bottom-b88a515ccdde)\"><polygon points=\"0 0, 0 1, 1 1, 1 0\"><\/polygon><\/clipPath><clipPath id=\"clip-bottom-b88a515ccdde\" class=\"decoration-clip clip-path-bottom\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"none\"><polygon points=\"0 0, 0 1, 1 1, 1 0\"><\/polygon><\/clipPath><\/defs><\/svg><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-16d97954e99\"><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-16d97954e9b\" style=\"--tcb-col-el-width: 595.906;\"><div class=\"tcb-flex-row tcb-resized tcb--cols--2\" data-css=\"tve-u-16d97954e93\"><div class=\"tcb-flex-col\" data-css=\"tve-u-16d97954e97\" style=\"\"><div class=\"tcb-col\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/5-Consejos-de-Formato-Condicional-en-Excel.xlsx\" target=\"_blank\" rel=\"\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display\" data-css=\"tve-u-16d97954e98\" data-link-wrap=\"1\"><svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-file-archive-light\" data-name=\"\">\n            <path d=\"M369.941 97.941l-83.882-83.882A48 48 0 0 0 252.118 0H48C21.49 0 0 21.49 0 48v416c0 26.51 21.49 48 48 48h288c26.51 0 48-21.49 48-48V131.882a48 48 0 0 0-14.059-33.941zM256 32.491a15.88 15.88 0 0 1 7.431 4.195l83.882 83.882a15.89 15.89 0 0 1 4.195 7.431H256V32.491zM352 464c0 8.837-7.164 16-16 16H48c-8.836 0-16-7.163-16-16V48c0-8.837 7.164-16 16-16h79.714v32h32V32H224v104c0 13.255 10.745 24 24 24h104v304zM192 96h-32V64h32v32zm-32 0v32h-32V96h32zm0 64v32h-32v-32h32zm32 0h-32v-32h32v32zm-9.838 96H160v-32h-32v32l-19.449 97.243C102.058 385.708 126.889 416 160 416c33.109 0 57.942-30.291 51.449-62.757l-17.519-87.596A12.001 12.001 0 0 0 182.162 256zM160.27 390.073c-17.918 0-32.444-12.105-32.444-27.036 0-14.932 14.525-27.036 32.444-27.036s32.444 12.104 32.444 27.036c0 14.931-14.526 27.036-32.444 27.036zM192 224h-32v-32h32v32z\"><\/path>\n        <\/svg><\/div><\/a><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-16d97954e92\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-16d97954e8f\"><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-16d97954e8c\" data-tag=\"h1\"><h1 data-css=\"tve-u-16d97954e94\" class=\"\"><a data-css=\"tve-u-16d97954e9c\" href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/5-Consejos-de-Formato-Condicional-en-Excel.xlsx\" target=\"_blank\" class=\"\" style=\"outline: none;\">Haz clic aqu\u00ed para Descargar el Archivo <\/a><\/h1><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" data-css=\"tve-u-16d97954e8a\"><p data-css=\"tve-u-16d97954e8e\"><strong>Haz clic en el enlace o bien en la imagen para descargar el archivo de 5 Ejemplos de Formato Condicional.<\/strong><\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d6630328e\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d6630327a\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Si te gusto el Contenido, comp\u00e1rtelo con tus amigos de Facebook, pulsando clic en compartir: <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\">Haz clic aqu\u00ed para compartir en Facebook \u2192<\/a><\/p><p style=\"\">Te Saluda,<\/p><p style=\"\">Roger Perez \u2013 Aplica Excel Contable<\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-16d97954e8a\"] { margin-top: 0px !important; margin-right: 2px !important; padding-bottom: 1px !important; padding-top: 1px !important; }[data-css=\"tve-u-16d97954e8c\"] { overflow: hidden; padding-bottom: 0px !important; margin-top: -3px !important; padding-top: 0px !important; border-radius: 10px !important; }:not(#tve) [data-css=\"tve-u-16d97954e8e\"] { font-size: 13px !important; color: rgb(6, 2, 2) !important; }[data-css=\"tve-u-16d97954e8f\"] { padding-bottom: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16d97954e90\"] { margin-left: 0px !important; padding-left: 10px !important; padding-bottom: 0px !important; padding-top: 0px !important; margin-bottom: 0px !important; margin-top: 0px !important; }[data-css=\"tve-u-16d97954e92\"] { max-width: 81.5%; }[data-css=\"tve-u-16d97954e93\"] > .tcb-flex-col > .tcb-col { min-height: 1px; }[data-css=\"tve-u-16d97954e93\"] { margin-left: 0px; min-height: inherit; }[data-css=\"tve-u-16d97954e93\"] > .tcb-flex-col { padding-left: 0px; }:not(#tve) [data-css=\"tve-u-16d97954e94\"] { font-size: 21px !important; color: rgb(15, 19, 190) !important; }[data-css=\"tve-u-16d97954e96\"] { clip-path: url(\"#clip-top-b88a515ccdde\"); -webkit-clip-path: url(\"#clip-top-b88a515ccdde\");  border-radius: 10px; overflow: hidden; border: 5px solid rgb(17, 133, 47) !important; }[data-css=\"tve-u-16d97954e97\"] { max-width: 18.5%; }[data-css=\"tve-u-16d97954e98\"] { margin-left: auto; margin-right: auto; font-size: 98px !important; margin-top: 0px !important; margin-bottom: 0px !important; width: 98px !important; height: 98px !important; }:not(#tve) [data-css=\"tve-u-16d97954e98\"] > :first-child { color: var(--tcb-color-0); }[data-css=\"tve-u-16d97954e99\"] p { margin: 0px 0px 12px !important; padding: 0px !important; }[data-css=\"tve-u-16d97954e9b\"] { margin-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-16d97954e9c\"] { font-size: 23px !important; }.tcb-post-list[data-css=\"tve-u-177256bad4b\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-177256bad4b\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-177256bad4b\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-177256bad4b\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-177256bad4b\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }:not(#tve) [data-css=\"tve-u-18d66223fd0\"] { font-size: 42px !important; color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0, 0, 0) !important; --tve-applied-color: rgb(0, 0, 0) !important; }[data-css=\"tve-u-18d66227fda\"] { margin-top: 20px !important; margin-bottom: 20px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-18d66233365\"] { --tve-font-size: 20px; --tve-color: rgb(7, 0, 0); --tve-applied---tve-color: rgb(7, 0, 0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66233365\"] h6 { color: var(--tve-color, rgb(7, 0, 0)); --tve-applied-color: var$(--tve-color, rgb(7, 0, 0)); --tcb-applied-color: rgb(7, 0, 0); }[data-css=\"tve-u-18d66233365\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18d6623337c\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-18d66274053\"] { font-size: 38px !important; color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0, 0, 0) !important; --tve-applied-color: rgb(0, 0, 0) !important; }[data-css=\"tve-u-18d662914f7\"] { width: 504px; --tve-alignment: center; margin-left: auto !important; margin-right: auto !important; float: none; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-18d66296505\"] { --tve-font-size: 20px; --tve-color: rgb(7, 0, 0); --tve-applied---tve-color: rgb(7, 0, 0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d66296505\"] h6 { color: var(--tve-color, rgb(7, 0, 0)); --tve-applied-color: var$(--tve-color, rgb(7, 0, 0)); --tcb-applied-color: rgb(7, 0, 0); }[data-css=\"tve-u-18d66296505\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18d66296517\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-18d662f3b7f\"] { width: 552px; --tve-alignment: center; margin-left: auto !important; margin-right: auto !important; float: none; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-18d6630327a\"] { --tve-font-size: 20px; --tve-color: rgb(7, 0, 0); --tve-applied---tve-color: rgb(7, 0, 0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d6630327a\"] h6 { color: var(--tve-color, rgb(7, 0, 0)); --tve-applied-color: var$(--tve-color, rgb(7, 0, 0)); --tcb-applied-color: rgb(7, 0, 0); }[data-css=\"tve-u-18d6630327a\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18d6630328e\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[3],"tags":[293,66,86,296],"class_list":["post-16824","post","type-post","status-publish","format-standard","hentry","category-aprender-excel","tag-aprender-excel","tag-excel","tag-formato-condicional","tag-formulas-excel","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/16824","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=16824"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/16824\/revisions"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=16824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=16824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=16824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}