{"id":26586,"date":"2017-11-01T15:16:33","date_gmt":"2017-11-01T21:16:33","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?page_id=26586"},"modified":"2022-01-22T22:30:11","modified_gmt":"2022-01-23T04:30:11","slug":"plan-de-proyecto-formato-condicional","status":"publish","type":"page","link":"https:\/\/aplicaexcelcontable.com\/blog\/plan-de-proyecto-formato-condicional","title":{"rendered":"Plan de Proyecto con Formato condicional"},"content":{"rendered":"<h1 style=\"text-align: center;\"><strong>VIDEO 6 &#8211; Como Crear tu Plan de Proyecto en Diagrama de Gannt con FC<\/strong><\/h1>\n<p style=\"text-align: justify;\">Comenzamos con los pasos de Como crear tu Plan de Proyecto con Formato Condicional, mira el Video:<\/p>\n<p><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Practica-Plan-de-Proyecto.xlsx\" target=\"_blank\" rel=\"noopener\">                    <\/a><\/p>\n<h1>\u200b<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Practica-Plan-de-Proyecto.xlsx\" style=\"outline: none;\" target=\"_blank\" rel=\"noopener\">Haz clic aqu\u00ed para Descargar el Archivo <\/a><\/h1>\n<p><strong>Haz clic en el enlace o bien en la imagen para descargar el archivo de Practica de Como Resaltar Filas Alternas.<\/strong><\/p>\n<p style=\"text-align: justify;\">Bienvenido a este video 6 del Mini Curso de Formato Condicional.<\/p>\n<p style=\"text-align: justify;\">En este video vamos a ver el tercer truco de Formato Condicional y se trata de los pasos de Como crear un Plan de Proyecto en Diagrama de Gantt.<\/p>\n<p style=\"text-align: justify;\">Estas listo para aplicar este nuevo truco en tus Planes de Proyecto?<\/p>\n<p style=\"text-align: justify;\">Comencemos:<\/p>\n<p><strong><\/p>\n<h2 dir=\"ltr\" style=\"text-align: center;\">Creando tu Plan de Proyecto en Diagrama de Gantt<\/h2>\n<p><\/strong><\/p>\n<p style=\"\"><span style=\"color: rgb(6, 1, 1);\">Como primer paso, vamos abrir el archivo de practica, si a un no lo tienes, te invito a que lo descargus, te lo he dejado justo debajo de este video.<\/span><\/p>\n<p style=\"\"><span style=\"color: rgb(6, 1, 1);\">Ya lo descargaste?<\/span><\/p>\n<p style=\"\"><span style=\"color: rgb(6, 1, 1);\">Muy bien, veamos el segundo paso:<\/span><\/p>\n<p style=\"\"><span style=\"color: rgb(6, 1, 1);\">Nos ubicamos en la F9 y escribimos la siguiente Formula: =SI(Y(F$8&gt;=$D9; F$8&lt;=$E9);\u00bb1&#8243;;\u00bb\u00bb).<\/span><\/p>\n<p style=\"\"><span style=\"color: rgb(6, 1, 1);\">Por lo tanto:<\/span><\/p>\n<p style=\"\"><span style=\"color: rgb(6, 1, 1);\">En seguida, seleccionamos de la F9 hasta la AO24, rellenamos la Formula hacia la derecha y luego hacia abajo.<\/span><\/p>\n<p style=\"\"><span style=\"color: rgb(6, 1, 1);\">Muy bien, estamos avanzado.<\/span><\/p>\n<p style=\"\"><span style=\"color: rgb(6, 1, 1);\">Ahora veamos el tercer paso:<\/span><\/p>\n<p style=\"\">Selecionamos nuevamente de la F9 hasta la AO24 y nos vamos a Formato Condicional.<\/p>\n<p style=\"\">Por lo tanto:<\/p>\n<p style=\"\">Dentro de este pulsamos clic en Nueva Regla, en este ventana, seleccionamos la opcion \u201cAplicar Formatos unicamente a las Celdas que contengan\u201d.<\/p>\n<p style=\"\">En la primera opcion seleccionamos Valor de la Celda, en la siguiente opcion igual a, y en el cuadro te texto escribimos: =\u201d1\u201d.<\/p>\n<p style=\"\">Ahora, pulsamos clic en formato y en fuete seleccionamos el color Azul enfasis 1.<\/p>\n<p style=\"\">Nos vamos a la seccion relleno y seleccionamos el color Azul enfasis 1, aceptamos y nuevamente aceptar.<\/p>\n<p style=\"\">En conclusi\u00f3n, hemos creado el Plan de Proyecto en Diagrama de Gantt utilizando Formato Condicional.<\/p>\n<h1 style=\"text-align: center;\">Sistema Contable V6.0<\/h1>\n<p><span style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/plantilla-contable-version-5-0.html\"><img decoding=\"async\" loading=\"lazy\" alt=\"Plan de Proyecto\" width=\"219\" height=\"109\" title=\"b48700d0b785828232c7626c68dd6c28.png\" src=\"\/\/i.pinimg.com\/originals\/b4\/87\/00\/b48700d0b785828232c7626c68dd6c28.png\" style=\"\" data-width=\"219\" data-height=\"109\" data-init-width=\"431\" data-init-height=\"214\"><\/a><\/span><\/p>\n<ul>\n<li>  <span>Genera Tus Cuentas Mayores<\/span><\/li>\n<li>  <span>Genera tu Balance de Resultado<\/span><\/li>\n<li>  <span>Imprime tu Balance General<\/span><\/li>\n<li>  <span>Lleva el Control de Tus Cuentas por Cobrar y Pagar<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Nos vemos en el Pr\u00f3ximo video donde vamos a ver: <strong>Como crear Gr\u00e1ficos Extremos en Celdas con Formato Condicional.<\/strong><\/p>\n<p style=\"text-align: justify;\">Que tal te pareci\u00f3 el video? Te gusto?<\/p>\n<p style=\"text-align: justify;\">Si te gusto compartelo con tus amigos de Facebook, pulsando clic en el boton Compartir:<\/p>\n<p style=\"text-align: justify;\">Para terminar, te invito a seguirnos en Facebook, para eso tan solo <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" rel=\"noopener\"><strong>pulsa clic aqui y visitanos.<\/strong><\/a><\/p>\n<p style=\"text-align: justify;\">Cualquier duda o pregunta, tan solo escribenos en el chat.<\/p>\n<p style=\"text-align: justify;\">Saludos,<\/p>\n<p style=\"text-align: justify;\"><strong>Roger Perez &#8211; Aplica Excel Contable<\/strong><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>VIDEO 6 &#8211; Como Crear tu Plan de Proyecto en Diagrama de Gannt con FC Comenzamos con los pasos de Como crear tu Plan de Proyecto con Formato Condicional, mira el Video: \u200bHaz clic aqu\u00ed para Descargar el Archivo Haz clic en el enlace o bien en la imagen para descargar el archivo de Practica [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-15f79585bae\" style=\"--tcb-col-el-width:1009;\"><div class=\"tcb-flex-row tcb-resized tcb--cols--2\" data-css=\"tve-u-15f79585bad\" style=\"\"><div class=\"tcb-flex-col\" data-css=\"tve-u-15f79585bc4\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\"><h1 class=\"\" data-css=\"tve-u-15f79585bc2\" style=\"text-align: center;\"><strong>VIDEO 6 - Como Crear tu Plan de Proyecto en Diagrama de Gannt con FC<\/strong><\/h1><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-15f79585bbd\" style=\"text-align: justify;\">Comenzamos con los pasos de Como crear tu Plan de Proyecto con Formato Condicional, mira el Video:<\/p><\/div><div class=\"thrv_wrapper thrv-button tve_ea_thrive_lightbox\" data-css=\"tve-u-16918fc17fc\" data-tcb_hover_state_parent=\"\" data-button-size=\"m\" style=\"\">\n\t<a href=\"\" class=\"tcb-button-link tve_evt_manager_listen tve_et_click tve-viewport-triggered\" data-tcb-events=\"__TCB_EVENT_[{&quot;config&quot;:{&quot;l_anim&quot;:&quot;instant&quot;,&quot;l_id&quot;:&quot;41355&quot;},&quot;a&quot;:&quot;thrive_lightbox&quot;,&quot;t&quot;:&quot;click&quot;}]_TNEVE_BCT__\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqu\u00ed para ver el Video \u2192<\/span><\/span>\n\t<\/a>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15f79585bdb\" style=\"margin-top: 20px !important;\"><div class=\"tve-content-box-background\" data-css=\"tve-u-15f79585be3\" 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\"><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width:702.844;\" data-css=\"tve-u-16f7b41d75e\"><div class=\"tcb-flex-row tcb-resized tcb--cols--2\" data-css=\"tve-u-15f79585bdf\" style=\"\"><div class=\"tcb-flex-col\" data-css=\"tve-u-15f79585bde\" style=\"\"><div class=\"tcb-col\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Practica-Plan-de-Proyecto.xlsx\" target=\"_blank\" rel=\"\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display\" data-css=\"tve-u-16f7b407fef\" style=\"\" data-link-wrap=\"1\"><svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-file-excel-solid\" data-name=\"\" style=\"\">\n            <path d=\"M224 136V0H24C10.7 0 0 10.7 0 24v464c0 13.3 10.7 24 24 24h336c13.3 0 24-10.7 24-24V160H248c-13.2 0-24-10.8-24-24zm60.1 106.5L224 336l60.1 93.5c5.1 8-.6 18.5-10.1 18.5h-34.9c-4.4 0-8.5-2.4-10.6-6.3C208.9 405.5 192 373 192 373c-6.4 14.8-10 20-36.6 68.8-2.1 3.9-6.1 6.3-10.5 6.3H110c-9.5 0-15.2-10.5-10.1-18.5l60.3-93.5-60.3-93.5c-5.2-8 .6-18.5 10.1-18.5h34.8c4.4 0 8.5 2.4 10.6 6.3 26.1 48.8 20 33.6 36.6 68.5 0 0 6.1-11.7 36.6-68.5 2.1-3.9 6.2-6.3 10.6-6.3H274c9.5-.1 15.2 10.4 10.1 18.4zM384 121.9v6.1H256V0h6.1c6.4 0 12.5 2.5 17 7l97.9 98c4.5 4.5 7 10.6 7 16.9z\"><\/path>\n        <\/svg><\/div><\/a><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-15f79585bdc\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-15f79585bda\" style=\"\"><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-15f79585bd8\" data-tag=\"h1\"><h1 class=\"\" data-css=\"tve-u-15f79585be0\"><a class=\"tve-froala fr-basic\" href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Practica-Plan-de-Proyecto.xlsx\" style=\"outline: none;\" target=\"_blank\">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-15f79585bd7\"><p data-css=\"tve-u-15f79585bd9\"><strong>Haz clic en el enlace o bien en la imagen para descargar el archivo de Practica de Como Resaltar Filas Alternas.<\/strong><\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15f79585baa\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15f79585bc5\"><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width:701.844;\" data-css=\"tve-u-16f7b42eec6\"><div class=\"tcb-flex-row tcb--cols--1\" data-css=\"tve-u-15f79585bab\" style=\"\"><div class=\"tcb-flex-col\"><div class=\"tcb-col tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-15f79585bbf\" style=\"text-align: justify;\">Bienvenido a este video 6 del Mini Curso de Formato Condicional.<\/p><p data-css=\"tve-u-15f79585bbf\" style=\"text-align: justify;\">En este video vamos a ver el tercer truco de Formato Condicional y se trata de los pasos de Como crear un Plan de Proyecto en Diagrama de Gantt.<\/p><p data-css=\"tve-u-15f79585bbf\" style=\"text-align: justify;\">Estas listo para aplicar este nuevo truco en tus Planes de Proyecto?<\/p><p data-css=\"tve-u-15f79585bbf\" style=\"text-align: justify;\">Comencemos:<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-15f79585bd2\" style=\"\"><strong class=\"\"><h2 data-css=\"tve-u-15f79585bd4\" dir=\"ltr\" style=\"text-align: center;\">Creando tu Plan de Proyecto en Diagrama de Gantt<\/h2><\/strong><br class=\"\"><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15f79585ba9\" style=\"\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15f79585bd6\"><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width:701.844;\" data-css=\"tve-u-16f7b442049\"><div class=\"tcb-flex-row tcb--cols--1\" style=\"\" data-css=\"tve-u-16f7b4433b9\"><div class=\"tcb-flex-col\"><div class=\"tcb-col tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" data-css=\"tve-u-16f7b437f84\" style=\"\"><p style=\"\"><span data-css=\"tve-u-15f796df8c4\" style=\"color: rgb(6, 1, 1);\">Como primer paso, vamos abrir el archivo de practica, si a un no lo tienes, te invito a que lo descargus, te lo he dejado justo debajo de este video.<\/span><\/p><p style=\"\"><span data-css=\"tve-u-15f796df8c4\" style=\"color: rgb(6, 1, 1);\">Ya lo descargaste?<\/span><\/p><p style=\"\"><span data-css=\"tve-u-15f796df8c4\" style=\"color: rgb(6, 1, 1);\">Muy bien, veamos el segundo paso:<\/span><\/p><p style=\"\"><span data-css=\"tve-u-15f796df8c4\" style=\"color: rgb(6, 1, 1);\">Nos ubicamos en la F9 y escribimos la siguiente Formula: =SI(Y(F$8&gt;=$D9; F$8&lt;=$E9);\"1\";\"\").<\/span><\/p><p style=\"\"><span data-css=\"tve-u-15f796df8c4\" style=\"color: rgb(6, 1, 1);\">Por lo tanto:<\/span><\/p><p style=\"\"><span data-css=\"tve-u-15f796df8c4\" style=\"color: rgb(6, 1, 1);\">En seguida, seleccionamos de la F9 hasta la AO24, rellenamos la Formula hacia la derecha y luego hacia abajo.<\/span><\/p><p style=\"\"><span data-css=\"tve-u-15f796df8c4\" style=\"color: rgb(6, 1, 1);\">Muy bien, estamos avanzado.<\/span><\/p><p style=\"\"><span data-css=\"tve-u-15f796df8c4\" style=\"color: rgb(6, 1, 1);\">Ahora veamos el tercer paso:<\/span><\/p><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" data-css=\"tve-u-15f79670564\" style=\"\"><p data-css=\"tve-u-15f79585ba6\" style=\"\">Selecionamos nuevamente de la F9 hasta la AO24 y nos vamos a Formato Condicional.<\/p><p data-css=\"tve-u-15f79585ba6\" style=\"\">Por lo tanto:<\/p><p data-css=\"tve-u-15f79585ba6\" style=\"\">Dentro de este pulsamos clic en Nueva Regla, en este ventana, seleccionamos la opcion \u201cAplicar Formatos unicamente a las Celdas que contengan\u201d.<\/p><p data-css=\"tve-u-15f79585ba6\" style=\"\">En la primera opcion seleccionamos Valor de la Celda, en la siguiente opcion igual a, y en el cuadro te texto escribimos: =\u201d1\u201d.<\/p><p data-css=\"tve-u-15f79585ba6\" style=\"\">Ahora, pulsamos clic en formato y en fuete seleccionamos el color Azul enfasis 1.<\/p><p data-css=\"tve-u-15f79585ba6\" style=\"\">Nos vamos a la seccion relleno y seleccionamos el color Azul enfasis 1, aceptamos y nuevamente aceptar.<\/p><p data-css=\"tve-u-15f79585ba6\" style=\"\">En conclusi\u00f3n, hemos creado el Plan de Proyecto en Diagrama de Gantt utilizando Formato Condicional.<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-15f79585bc3\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-15f79585bc0\"><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15fa7da4ebf\" style=\"margin-top: 87px !important;\"><div class=\"tve-content-box-background\" data-css=\"tve-u-15fa7da4ecc\"><\/div><div class=\"tve-cb tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-15fa7da4ec3\" data-tag=\"h1\"><h1 class=\"\" data-css=\"tve-u-15fa7da4ece\" style=\"text-align: center;\">Sistema Contable V6.0<\/h1><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-15fa7da4ecb\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/plantilla-contable-version-5-0.html\"><img loading=\"lazy\" class=\"tve_image\" alt=\"Plan de Proyecto\" width=\"219\" height=\"109\" title=\"b48700d0b785828232c7626c68dd6c28.png\" src=\"\/\/i.pinimg.com\/originals\/b4\/87\/00\/b48700d0b785828232c7626c68dd6c28.png\" style=\"\" data-width=\"219\" data-height=\"109\" data-init-width=\"431\" data-init-height=\"214\"><\/a><\/span><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(22, 150, 46)\" data-css=\"tve-u-15fa7da4ec5\" data-icons-size=\"18\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-15fa7da4ed0\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-15fa7da4ec8\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"check\"> <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=\"tve_editable tcb-styled-list-icon-text tcb-no-delete thrv-advanced-inline-text\" data-css=\"tve-u-15fa7da4ed4\">Genera Tus Cuentas Mayores<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-15fa7da4ed3\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-15fa7da4ec7\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"check\"> <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=\"tve_editable tcb-styled-list-icon-text tcb-no-delete thrv-advanced-inline-text\">Genera tu Balance de Resultado<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-15fa7da4ed2\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-15fa7da4ec6\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"check\"> <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=\"tve_editable tcb-styled-list-icon-text tcb-no-delete thrv-advanced-inline-text\">Imprime tu Balance General<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-15fa7da4ed1\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-15fa7da4eca\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"check\"> <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=\"tve_editable tcb-styled-list-icon-text tcb-no-delete thrv-advanced-inline-text\" data-css=\"tve-u-15fa7da4ec9\">Lleva el Control de Tus Cuentas por Cobrar y Pagar<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv-button\" data-css=\"tve-u-15fa7da4ec2\" style=\"\"> <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/sistema-contable-v6-0\" class=\"tcb-button-link\" target=\"_blank\"> <span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\" data-css=\"tve-u-15fa7da4ec1\"><strong>Ordenalo Ahora<\/strong><\/span><\/span> <\/a><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width:1009;\" data-css=\"tve-u-16f7b49224f\"><div class=\"tcb-flex-row tcb--cols--1\" style=\"\" data-css=\"tve-u-16f7b4945b7\"><div class=\"tcb-flex-col\" data-css=\"tve-u-15f51534824\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15f79585bcd\" style=\"margin-top: 0px !important;\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15f79585bd5\"><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width:1007;\" data-css=\"tve-u-16f7b46fea8\"><div class=\"tcb-flex-row tcb--cols--1\"><div class=\"tcb-flex-col\"><div class=\"tcb-col tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-15f79585bcf\" style=\"text-align: justify;\">Nos vemos en el Pr\u00f3ximo video donde vamos a ver: <strong>Como crear Gr\u00e1ficos Extremos en Celdas con Formato Condicional.<\/strong><\/p><p data-css=\"tve-u-15f79585bce\" style=\"text-align: justify;\">Que tal te pareci\u00f3 el video? Te gusto?<\/p><p data-css=\"tve-u-15f79585bce\" style=\"text-align: justify;\">Si te gusto compartelo con tus amigos de Facebook, pulsando clic en el boton Compartir:<br><br><\/p><\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-15f79585bcc\"><div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb\"><div class=\"tve_s_item tve_s_fb_share\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/plan-de-proyecto-formato-condicional\" data-label=\"Compartir\"> <a href=\"javascript:void(0)\" class=\"tve_s_link\"><span class=\"tve_s_icon thrv-svg-icon\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"tcb-facebook\" viewBox=\"0 0 16 28\"><path d=\"M14.984 0.187v4.125h-2.453q-1.344 0-1.813 0.562t-0.469 1.687v2.953h4.578l-0.609 4.625h-3.969v11.859h-4.781v-11.859h-3.984v-4.625h3.984v-3.406q0-2.906 1.625-4.508t4.328-1.602q2.297 0 3.563 0.187z\"><\/path><\/svg><\/span><span class=\"tve_s_text\">Compartir<\/span><span class=\"tve_s_count\">0<\/span><\/a><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" data-css=\"tve-u-15f79585bc8\"><p data-css=\"tve-u-15f79585bcb\" style=\"text-align: justify;\">Para terminar, te invito a seguirnos en Facebook, para eso tan solo <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\"><strong>pulsa clic aqui y visitanos.<\/strong><\/a><\/p><p data-css=\"tve-u-15f79585bcb\" style=\"text-align: justify;\">Cualquier duda o pregunta, tan solo escribenos en el chat.<\/p><p data-css=\"tve-u-15f79585bcb\" style=\"text-align: justify;\">Saludos,<\/p><p data-css=\"tve-u-15f79585bcb\" style=\"text-align: justify;\"><strong>Roger Perez - Aplica Excel Contable<\/strong><\/p><p data-css=\"tve-u-15f79585bca\"><br><\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-15f796df8c4\"] { color: rgb(6, 1, 1) !important; }[data-css=\"tve-u-15f79670564\"] { margin-top: 0px !important; }:not(#tve) [data-css=\"tve-u-15f79585ba6\"] { color: rgb(6, 1, 1) !important; }[data-css=\"tve-u-15f79585ba9\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-15f79585baa\"] { margin-top: 20px !important; padding-top: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-15f79585bab\"] { padding-top: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-15f79585bad\"] { padding-top: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-15f79585bae\"] { margin-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-15f79585bbd\"] { color: rgb(6, 2, 2) !important; }:not(#tve) [data-css=\"tve-u-15f79585bbf\"] { color: rgb(8, 3, 3) !important; }[data-css=\"tve-u-15f79585bc0\"] { margin-top: -16px !important; }:not(#tve) [data-css=\"tve-u-15f79585bc2\"] { font-size: 27px !important; color: rgb(244, 2, 2) !important; }[data-css=\"tve-u-15f79585bc3\"] { max-width: 29.8%; }[data-css=\"tve-u-15f79585bc4\"] { max-width: 70.2%; }[data-css=\"tve-u-15f79585bc5\"] p { margin: 0px 0px 15px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bc5\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bc5\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bc5\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bc5\"] address { line-height: 1.45em; }[data-css=\"tve-u-15f79585bc8\"] { margin-top: -34px !important; }:not(#tve) [data-css=\"tve-u-15f79585bca\"] { color: rgb(7, 4, 4) !important; }:not(#tve) [data-css=\"tve-u-15f79585bcb\"] { color: rgb(7, 4, 4) !important; }[data-css=\"tve-u-15f79585bcc\"] { float: none; margin-top: -27px !important; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-15f79585bcd\"] { margin-top: -84px !important; }:not(#tve) [data-css=\"tve-u-15f79585bce\"] { color: rgb(6, 2, 2) !important; }:not(#tve) [data-css=\"tve-u-15f79585bcf\"] { color: rgb(6, 2, 2) !important; }[data-css=\"tve-u-15f79585bd2\"] { margin-top: 0px !important; padding-bottom: 0px !important; padding-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-15f79585bd4\"] { font-size: 27px !important; color: rgb(249, 8, 8) !important; }[data-css=\"tve-u-15f79585bd5\"] p { margin: 0px 0px 15px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bd5\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bd5\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bd5\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bd5\"] address { line-height: 1.45em; }[data-css=\"tve-u-15f79585bd6\"] p { margin: 0px 0px 15px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bd6\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bd6\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bd6\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f79585bd6\"] address { line-height: 1.45em; }[data-css=\"tve-u-15f79585bd7\"] { margin-top: -24px !important; }[data-css=\"tve-u-15f79585bd8\"] { padding-bottom: 0px !important; margin-top: -3px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-15f79585bd9\"] { font-size: 13px !important; color: rgb(6, 2, 2) !important; }[data-css=\"tve-u-15f79585bda\"] { padding-bottom: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-15f79585bdb\"] { margin-left: 0px !important; padding-left: 0px !important; padding-bottom: 0px !important; padding-top: 0px !important; margin-bottom: 0px !important; margin-top: 20px !important; }[data-css=\"tve-u-15f79585bdc\"] { max-width: 80.9%; }[data-css=\"tve-u-15f79585bde\"] { max-width: 19.1%; }[data-css=\"tve-u-15f79585bdf\"] > .tcb-flex-col > .tcb-col { min-height: 1px; }[data-css=\"tve-u-15f79585bdf\"] { margin-left: 0px; min-height: inherit; padding-bottom: 0px !important; }[data-css=\"tve-u-15f79585bdf\"] > .tcb-flex-col { padding-left: 0px; }:not(#tve) [data-css=\"tve-u-15f79585be0\"] { font-size: 21px !important; color: rgb(15, 19, 190) !important; }[data-css=\"tve-u-15f79585be3\"] { 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-15fa7da4ebf\"] { margin-top: 87px !important; }:not(#tve) [data-css=\"tve-u-15fa7da4ec1\"] { color: rgb(7, 3, 3) !important; }[data-css=\"tve-u-15fa7da4ec2\"] .tcb-button-link { background-image: none !important; background-color: rgb(242, 208, 24) !important; }[data-css=\"tve-u-15fa7da4ec3\"] { margin-top: 8px !important; padding-left: 8px !important; }[data-css=\"tve-u-15fa7da4ec5\"] { padding-left: 0px !important; margin-left: 5px !important; }:not(#tve) [data-css=\"tve-u-15fa7da4ec5\"] p, :not(#tve) [data-css=\"tve-u-15fa7da4ec5\"] li, :not(#tve) [data-css=\"tve-u-15fa7da4ec5\"] blockquote, :not(#tve) [data-css=\"tve-u-15fa7da4ec5\"] address { color: rgb(3, 1, 1); font-size: 14px; }[data-css=\"tve-u-15fa7da4ec6\"] { color: rgb(22, 150, 46); }[data-css=\"tve-u-15fa7da4ec7\"] { color: rgb(22, 150, 46); }[data-css=\"tve-u-15fa7da4ec8\"] { color: rgb(22, 150, 46); }:not(#tve) [data-css=\"tve-u-15fa7da4ec9\"] { font-size: 14px !important; color: rgb(7, 2, 2) !important; }[data-css=\"tve-u-15fa7da4ec9\"] { line-height: 1.4em !important; }[data-css=\"tve-u-15fa7da4eca\"] { color: rgb(22, 150, 46); }[data-css=\"tve-u-15fa7da4ecb\"] + div { clear: none; }[data-css=\"tve-u-15fa7da4ecb\"] { float: none; margin-left: auto; margin-right: auto; width: 219px; margin-top: -21px !important; }[data-css=\"tve-u-15fa7da4ecc\"] { border: 3px solid rgb(9, 6, 245) !important; }:not(#tve) [data-css=\"tve-u-15fa7da4ece\"] { font-size: 23px !important; color: rgb(246, 14, 45) !important; }[data-css=\"tve-u-16918fc17fc\"] .tcb-button-link { border-color: rgb(255, 231, 231); padding: 14px 22px; border-radius: 10px; overflow: hidden; background-image: none !important; background-color: rgb(244, 124, 11) !important; }:not(#tve) [data-css=\"tve-u-16918fc17fc\"]:hover .tcb-button-link { background-color: rgb(218, 113, 8) !important; }:not(#tve) [data-css=\"tve-u-16918fc17fc\"] .tcb-button-link { line-height: 1.2em; font-size: 24px; }[data-css=\"tve-u-16918fc17fc\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-15f79585bae\"] p { padding: 0px 0px 13px !important; margin: 0px !important; }[data-css=\"tve-u-16f7b407fef\"] { font-size: 60px; margin-left: auto; margin-right: auto; margin-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-16f7b407fef\"] > :first-child { color: rgb(3, 71, 11); }[data-css=\"tve-u-16f7b41d75e\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16f7b42eec6\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16f7b437f84\"] { margin-top: 0px !important; }[data-css=\"tve-u-16f7b442049\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16f7b4433b9\"] { padding-bottom: 0px !important; padding-top: 0px !important; }[data-css=\"tve-u-16f7b46fea8\"] { margin-top: 0px !important; }[data-css=\"tve-u-16f7b442049\"] p { padding: 0px 0px 10px !important; margin: 0px !important; }[data-css=\"tve-u-16f7b49224f\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16f7b4945b7\"] { padding-top: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-15fa7da4ec2\"] { margin-top: 0px !important; }}@media (max-width: 1023px){:not(#tve) [data-css=\"tve-u-15fa7da4ec1\"] { font-size: 12px !important; }[data-css=\"tve-u-15fa7da4ed0\"] { max-width: 97px; }[data-css=\"tve-u-15fa7da4ed1\"] { max-width: 95px; }[data-css=\"tve-u-15fa7da4eca\"] { font-size: 18px; width: 18px; height: 18px; margin-right: 8px !important; padding-right: 3px !important; margin-left: -14px !important; padding-left: 0px !important; }[data-css=\"tve-u-15fa7da4ed2\"] { max-width: 97px; margin-right: -9px !important; padding-right: 0px !important; }[data-css=\"tve-u-15fa7da4ec6\"] { font-size: 18px; width: 18px; height: 18px; margin-left: -14px !important; padding-left: 0px !important; padding-right: 16px !important; margin-right: 24px !important; }[data-css=\"tve-u-15fa7da4ed3\"] { max-width: 101px; margin-right: -16px !important; padding-right: 0px !important; padding-left: 14px !important; margin-left: -2px !important; }[data-css=\"tve-u-15fa7da4ec7\"] { font-size: 18px; width: 18px; height: 18px; margin-right: 56px !important; margin-left: -13px !important; padding-left: 0px !important; }[data-css=\"tve-u-15fa7da4ec8\"] { font-size: 18px; width: 18px; height: 18px; margin-left: -15px !important; padding-left: 0px !important; padding-right: 26px !important; margin-right: 14px !important; }:not(#tve) [data-css=\"tve-u-15fa7da4ed4\"] { font-size: 13px !important; }:not(#tve) [data-css=\"tve-u-15fa7da4ece\"] { font-size: 13px !important; }[data-css=\"tve-u-15fa7da4ecb\"] { width: 106px; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"0","_tve_footer":"0"},"class_list":["post-26586","page","type-page","status-publish","hentry","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/pages\/26586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"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=26586"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/pages\/26586\/revisions"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=26586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}