{"id":16810,"date":"2014-06-30T10:31:23","date_gmt":"2014-06-30T16:31:23","guid":{"rendered":"http:\/\/aplicaexcelcontable.com\/blog\/?p=16810"},"modified":"2024-01-20T16:58:16","modified_gmt":"2024-01-20T22:58:16","slug":"5-consejos-para-aplicar-formato-condicional-en-excel","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/5-consejos-para-aplicar-formato-condicional-en-excel.html","title":{"rendered":"5 Consejos para Aplicar Formato Condicional en Excel"},"content":{"rendered":"<h1 style=\"text-align: center;\">5 Consejos para Aplicar Formato Condicional en Excel<\/h1>\n<p style=\"text-align: justify;\">El formato condicional de Excel es una joya escondida y poderosa que cuando se utiliza bien, puede cambiar la perspectiva de su proyecto de informe \/ ventas &#8211; presupuesto \/ plan de proyecto o resultados anal\u00edticos de un mont\u00f3n de datos bruto en fuentes por defecto a algo verdaderamente profesional y de buen aspecto.<span class=\"apple-converted-space\">\u00a0<\/span>Mejor a\u00fan, usted incluso no necesita ser un gur\u00fa o excel pro para lograr resultados espectaculares.<span class=\"apple-converted-space\">\u00a0<\/span>Todo lo que necesitas es un poco de caf\u00e9 y este post para aprender algunos trucos de formato condicional.<\/p>\n<p>As\u00ed que, ya tienes tu taza de caf\u00e9?\u00a0Bueno, vamos a empezar!<\/p>\n<h3><span style=\"color: #ff0000;\"><strong>Los 5 trucos que vamos a aprender son,<\/strong><\/span><\/h3>\n<p><strong> 1.<\/strong>\u00a0<strong>Resaltar filas alternativas \/ columnas en las tablas<\/strong><br \/>\n<strong> 2.\u00a0Inteligente Plan de Proyectos en Diagrama de Gantt<\/strong><br \/>\n<strong> 3.\u00a0Gr\u00e1ficos Extremos en Celdas<\/strong><br \/>\n<strong> 4.\u00a0Resaltar errores, omisiones y \u00a0repeticiones<\/strong><br \/>\n<strong> 5.\u00a0Crear cuadros de mando intuitivos<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>Si no conoces q es formato condicional en Excel, por favor <span style=\"color: #ff0000;\"><a title=\"Que Es Formato Condicional?\" href=\"https:\/\/aplicaexcelcontable.com\/blog\/formato-condicional-en-excel-fundamentos.html\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color: #ff0000;\">Haz Clic aqu\u00ed<\/span><\/a><\/span> y \u00a0lea el<\/strong><strong>\u00a0fundamento de Formato Condicional antes <\/strong><strong>\u00a0de continuar.<\/strong><\/p>\n<p style=\"text-align: justify;\">He creado una hoja de Excel que contiene todos los Cinco \u00a0ejemplos.\u00a0Ahora Mismo Puedes Descargalo:<\/p>\n<h2>Resaltar filas alternativas \/ columnas en tablas Excel:<\/h2>\n<p style=\"text-align: justify;\">En Ocasiones, cuando usted presenta los datos de una tabla grande que parece mon\u00f3tono y dif\u00edcil de leer.\u00a0Esto se debe a que sus<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/Consejo-1-Formato-Condicional-en-Excel.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-16815\" title=\"Excel, formula, formato Condicional, Aprender Excel\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/Consejo-1-Formato-Condicional-en-Excel-300x136.png\" alt=\"Consejo 1 Formato Condicional en Excel\" width=\"416\" height=\"190\" srcset=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/Consejo-1-Formato-Condicional-en-Excel-300x136.png 300w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/Consejo-1-Formato-Condicional-en-Excel.png 776w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/a> ojos comienzan la interpretaci\u00f3n de los datos de Forma Generalizada en lugar de Centrarse en algunos n\u00fameros importantes.\u00a0Para romper este obst\u00e1culo intenta destacar o cambiar el color de fondo de las filas o columnas alternativas.\u00a0Pero \u00bfc\u00f3mo hacer estos Resaltas en la Fila o Columna?.\u00a0El truco radica en el Formato condicional.(Por supuesto, usted puede utilizar la funci\u00f3n de formato autom\u00e1tico incorporado, pero todos sabemos c\u00f3mo la configuraci\u00f3n predeterminada de los diversos productos de Microsoft son similares).<\/p>\n<ul>\n<li>Primero, seleccione los datos de la tabla que desea dar formato.<\/li>\n<li>Ir al cuadro de di\u00e1logo Formato condicional (INICIO&gt; Estilos&gt; Formato condicional &gt; Nueva Regla).<\/li>\n<li>Cambiar \u00abAplicar Formato a todas Celdas Seg\u00fan su Valores\u00bb a \u00abUtilice una f\u00f3rmula que determine las Celdas para Aplica Formatos \u00bb (S\u00ed, usted puede basar su resultado en formato f\u00f3rmulas en lugar de los valores de celda)<\/li>\n<li>Ahora, si desea resaltar filas alternativas, la f\u00f3rmula puede ser la siguiente:<\/li>\n<\/ul>\n<p><strong>= RECIDUO (FILAS (), 2) = 0<\/strong><\/p>\n<p style=\"text-align: justify;\">lo que significa que cada vez que la fila () de la celda actual es par, El color Cambiara, Ahora para cambiar el color de las filas impares , s\u00f3lo tiene que poner <strong>= RECIDUO (FILA (), 2) = 1<\/strong> como f\u00f3rmula,\u00a0Adem\u00e1s, si desea resaltar columnas alternativas en vez de filas puedes utilizar columna (en la f\u00f3rmula).\u00a0\u00bfQu\u00e9 pasa si usted quiere cambiar el color de fondo de cada tercera fila en vez de la segunda Fila, s\u00f3lo tiene que utilizar<strong> = RECIDUO (FILAS (), 3) = 0<\/strong> en lugar de 2.\u00a0S\u00f3lo tienes que utilizar tu imaginaci\u00f3n.<\/p>\n<ul>\n<li>Ajuste el formato que quieras, en mi caso he utilizado el color amarillo.\u00a0Cuando haya terminado, el di\u00e1logo debe ser algo como esto:<\/li>\n<\/ul>\n<p><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/Consejo-1-Formato-Condicional.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16817 size-full\" title=\"Excel, formula, formato Condicional, Aprender Excel\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/Consejo-1-Formato-Condicional.png\" alt=\"Consejo 1 Formato Condicional\" width=\"520\" height=\"372\" srcset=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/Consejo-1-Formato-Condicional.png 520w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/Consejo-1-Formato-Condicional-300x214.png 300w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/Consejo-1-Formato-Condicional-78x55.png 78w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/a><\/p>\n<ul>\n<li>Clic en Aceptar.<\/li>\n<li>Felicidades, ahora ya manejas un Truco de Formato Condicional.<\/li>\n<\/ul>\n<p>Muy bien, continuamos con mas consejos en el proximo articulo, pero antes si tienes dudas o preguntas solo escribeme al final de este post.<\/p>\n<p>Tambien, te invito a que compartas este contenido 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>5 Consejos para Aplicar Formato Condicional en Excel El formato condicional de Excel es una joya escondida y poderosa que cuando se utiliza bien, puede cambiar la perspectiva de su proyecto de informe \/ ventas &#8211; presupuesto \/ plan de proyecto o resultados anal\u00edticos de un mont\u00f3n de datos bruto en fuentes por defecto a [&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-18d28ce7c41\" style=\"\"><h1 style=\"text-align: center;\" class=\"\" data-css=\"tve-u-18d28ce0fe6\">5 consejos para aplicar formato condicional en Excel<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d28d65c89\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d28d65c75\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">El formato condicional de Excel es una joya escondida y poderosa que cuando se utiliza bien, puede cambiar la perspectiva de su proyecto de informe \/ ventas - presupuesto \/ plan de proyecto o resultados anal\u00edticos de un mont\u00f3n de datos bruto en fuentes por defecto a algo verdaderamente profesional y de buen aspecto.&nbsp;<\/p><p style=\"\">Mejor a\u00fan, usted incluso no necesita ser un gur\u00fa o excel pro para lograr resultados espectaculares. Todo lo que necesitas es un poco de caf\u00e9 y este post para aprender algunos trucos de formato condicional.<\/p><p style=\"\">As\u00ed que, ya tienes tu taza de caf\u00e9? Bueno, vamos a empezar!<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18d28ea5252\" style=\"\"><h2 data-css=\"tve-u-18d28ea7ede\" style=\"text-align: center;\" class=\"\">Los 5 trucos que vamos a aprender son:<\/h2><\/div><div class=\"thrv_wrapper thrv-numbered_list\" data-start-number=\"1\" data-number-increment=\"1\"><ol class=\"tcb-numbered-list\"><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\"><span class=\"tcb-numbered-list-index\">1<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d28f565ae\"><div style=\"text-align: justify;\">Resaltar filas alternativas\/Columnas en las Tablas<\/div><\/span><\/li><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\"><span class=\"tcb-numbered-list-index\">2<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d28f565ae\"><div style=\"text-align: justify;\">Inteligente plan de proyectos en diagrama de Gantt<\/div><\/span><\/li><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\"><span class=\"tcb-numbered-list-index\">3<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d28f565ae\">Gr\u00e1ficos extremos en celdas<\/span><\/li><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag \"><span class=\"tcb-numbered-list-index\">4<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d28f565ae\">Resaltar errores, omisiones y repeticiones<\/span><\/li><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\"><span class=\"tcb-numbered-list-index\">5<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d28f565ae\">Crear cuadros de mando intuitivos<\/span><\/li><\/ol><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d28fbf341\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d28fbf32c\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Si no conoces q es formato condicional en Excel, por favor Haz Clic aqu\u00ed y &nbsp;lea el&nbsp;fundamento de Formato Condicional antes &nbsp;de continuar.<\/p><p style=\"\">He creado una hoja de Excel que contiene todos los cinco ejemplos. Ahora mismo puedes descargarlo:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16d978b270b\"><div class=\"tve-content-box-background\" data-css=\"tve-u-16d978b2710\" 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-16d978b2714\"><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-16d978b2715\" style=\"--tcb-col-el-width: 595.906;\"><div class=\"tcb-flex-row tcb-resized tcb--cols--2\" data-css=\"tve-u-16d978b270e\"><div class=\"tcb-flex-col\" data-css=\"tve-u-16d978b2711\" 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-16d978b2713\" 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-16d978b270c\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-16d978b270a\"><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-16d978b2707\" data-tag=\"h3\"><h3 data-css=\"tve-u-16d978b270f\" class=\"\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/06\/5-Consejos-de-Formato-Condicional-en-Excel.xlsx\" target=\"_blank\"> Haz Clic aqu\u00ed y Descarga el Ejemplo 5 Consejos<\/a><\/h3><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" data-css=\"tve-u-16d978b2705\"><p data-css=\"tve-u-16d978b2708\"><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_text_element\" data-css=\"tve-u-18d28ea5252\" style=\"\"><h3 style=\"text-align: center;\" class=\"\" data-css=\"tve-u-18d28ff238f\">Resaltar filas alternativas\/columnas en Tablas Excel<\/h3><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18d29073539\"><span class=\"tve_image_frame\"><img class=\"tve_image wp-image-58223\" alt=\"\" data-id=\"58223\" width=\"300\" data-init-width=\"300\" height=\"136\" data-init-height=\"136\" title=\"Consejo 1 - Formato Condicional en Excel\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/01\/Consejo-1-Formato-Condicional-en-Excel.png\" data-width=\"300\" data-height=\"136\" style=\"aspect-ratio: auto 300 \/ 136;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d28fbf341\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d28fbf32c\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">En Ocasiones, cuando usted presenta los datos de una tabla grande que parece mon\u00f3tono y dif\u00edcil de leer. Esto se debe a que sus ojos comienzan la interpretaci\u00f3n de los datos de Forma Generalizada en lugar de Centrarse en algunos n\u00fameros importantes.<\/p><p style=\"\">Para romper este obst\u00e1culo intenta destacar o cambiar el color de fondo de las filas o columnas alternativas. Pero \u00bfC\u00f3mo hacer estos resaltas en la fila o columna?.&nbsp;<\/p><p style=\"\">El truco radica en el Formato condicional. (Por supuesto, usted puede utilizar la funci\u00f3n de formato autom\u00e1tico incorporado, pero todos sabemos c\u00f3mo la configuraci\u00f3n predeterminada de los diversos productos de Microsoft son similares).<\/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-18d290a8007\"><div style=\"text-align: justify;\">Primero, seleccione los datos de la tabla que desea dar formato.<\/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-18d290a8007\"><div style=\"text-align: justify;\">Ir al cuadro de di\u00e1logo Formato condicional (INICIO&gt; Estilos&gt; Formato condicional &gt; Nueva Regla).<\/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-18d290a8007\"><div style=\"text-align: justify;\">Cambiar \u00abAplicar Formato a todas Celdas Seg\u00fan su Valores\u00bb a \u00abUtilice una f\u00f3rmula que determine las Celdas para Aplica Formatos \u00bb (S\u00ed, usted puede basar su resultado en formato f\u00f3rmulas en lugar de los valores de celda)<\/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\" data-css=\"tve-u-18d290bcbf0\"><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-18d290a8007\"><div style=\"text-align: justify;\">Ahora, si desea resaltar filas alternativas, la f\u00f3rmula puede ser la siguiente:<\/div><\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d28fbf341\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d28fbf32c\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">= RECIDUO (FILAS (), 2) = 0<\/p><p style=\"\">Lo que significa que cada vez que la fila () de la celda actual es par, el color Cambiara, Ahora para cambiar el color de las filas impares , s\u00f3lo tiene que poner = RECIDUO (FILA (), 2) = 1 como f\u00f3rmula, adem\u00e1s, si desea resaltar columnas alternativas en vez de filas puedes utilizar columna (en la f\u00f3rmula).&nbsp;<\/p><p style=\"\">\u00bfQu\u00e9 pasa si usted quiere cambiar el color de fondo de cada tercera fila en vez de la segunda Fila, s\u00f3lo tiene que utilizar = RECIDUO (FILAS (), 3) = 0 en lugar de 2. S\u00f3lo tienes que utilizar tu imaginaci\u00f3n.<\/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-18d29109f83\"><div style=\"text-align: justify;\">Ajuste el formato que quieras, en mi caso he utilizado el color amarillo. Cuando haya terminado, el di\u00e1logo debe ser algo como esto:<\/div><\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18d29106f90\"><span class=\"tve_image_frame\"><img class=\"tve_image wp-image-58224\" alt=\"\" data-id=\"58224\" width=\"520\" data-init-width=\"520\" height=\"372\" data-init-height=\"372\" title=\"Consejo 1 - Formato Condicional\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/01\/Consejo-1-Formato-Condicional.png\" data-width=\"520\" data-height=\"372\" style=\"aspect-ratio: auto 520 \/ 372;\"><\/span><\/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-18d290eb28b\"><div style=\"text-align: justify;\">Clic en Aceptar.<\/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\" data-css=\"tve-u-18d29115c80\"><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-18d290eb28b\"><div style=\"text-align: justify;\">Felicidades, ahora ya manejas un Truco de Formato Condicional.<\/div><\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d29120560\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d2912054a\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Muy bien, continuamos con mas consejos en el pr\u00f3ximo articulo, pero antes si tienes dudas o preguntas solo escr\u00edbeme al final de este post.<\/p><p style=\"\">Tambi\u00e9n, te invito a que compartas este contenido con tus amigos de Facebook, pulsando clic en compartir:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social tve_share_left\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-18d2916a4b7\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb tve-prevent-content-edit\">\n<div class=\"tve_s_item tve_s_fb_share thrv_wrapper tve_share_item\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/sistema-de-facturacion-en-excel.html\" data-label=\"Compartir\" data-css=\"tve-u-18be2dd4a6b\">\n<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\" wfd-invisible=\"true\">0<\/span><\/a>\n<\/div>\n<\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d29120560\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d2912054a\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Te saluda,<\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-16d978b2705\"] { margin-top: 0px !important; margin-right: 2px !important; padding-bottom: 1px !important; padding-top: 1px !important; }[data-css=\"tve-u-16d978b2707\"] { overflow: hidden; padding-bottom: 0px !important; margin-top: -3px !important; padding-top: 0px !important; border-radius: 10px !important; }:not(#tve) [data-css=\"tve-u-16d978b2708\"] { font-size: 13px !important; color: rgb(6, 2, 2) !important; }[data-css=\"tve-u-16d978b270a\"] { padding-bottom: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16d978b270b\"] { 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-16d978b270c\"] { max-width: 81.5%; }[data-css=\"tve-u-16d978b270e\"] > .tcb-flex-col > .tcb-col { min-height: 1px; }[data-css=\"tve-u-16d978b270e\"] { margin-left: 0px; min-height: inherit; }[data-css=\"tve-u-16d978b270e\"] > .tcb-flex-col { padding-left: 0px; }:not(#tve) [data-css=\"tve-u-16d978b270f\"] { font-size: 21px !important; color: rgb(15, 19, 190) !important; }[data-css=\"tve-u-16d978b2710\"] { 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-16d978b2711\"] { max-width: 18.5%; }[data-css=\"tve-u-16d978b2713\"] { 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-16d978b2713\"] > :first-child { color: var(--tcb-color-0); }[data-css=\"tve-u-16d978b2714\"] p { margin: 0px 0px 12px !important; padding: 0px !important; }[data-css=\"tve-u-16d978b2715\"] { margin-top: 0px !important; margin-bottom: 0px !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-18d28ce0fe6\"] { color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0, 0, 0) !important; --tve-applied-color: rgb(0, 0, 0) !important; font-size: 42px !important; }[data-css=\"tve-u-18d28ce7c41\"] { margin-top: 20px !important; margin-bottom: 20px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-18d28d65c75\"] { --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-18d28d65c75\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28d65c75\"] 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-18d28d65c75\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18d28d65c89\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-18d28ea5252\"] { margin-top: 20px !important; margin-bottom: 20px !important; }:not(#tve) [data-css=\"tve-u-18d28ea7ede\"] { color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0, 0, 0) !important; --tve-applied-color: rgb(0, 0, 0) !important; font-size: 38px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-18d28fbf32c\"] { --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-18d28fbf32c\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d28fbf32c\"] 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-18d28fbf32c\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18d28fbf341\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-18d28ff238f\"] { 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-18d29073539\"] { width: 300px; --tve-alignment: center; margin-left: auto !important; margin-right: auto !important; float: none; }[data-css=\"tve-u-18d29106f90\"] { width: 520px; --tve-alignment: center; margin-left: auto !important; margin-right: auto !important; float: none; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-18d2912054a\"] { --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-18d2912054a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d2912054a\"] 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-18d2912054a\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18d29120560\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-18d2916a4b7\"] { float: none; margin-left: auto !important; margin-right: auto !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,87],"class_list":["post-16810","post","type-post","status-publish","format-standard","hentry","category-aprender-excel","tag-aprender-excel","tag-excel","tag-formato-condicional","tag-formula","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/16810","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=16810"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/16810\/revisions"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=16810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=16810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=16810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}