{"id":26512,"date":"2017-10-30T11:13:39","date_gmt":"2017-10-30T17:13:39","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?page_id=26512"},"modified":"2024-01-31T16:58:39","modified_gmt":"2024-01-31T22:58:39","slug":"resaltar-filas-alternas","status":"publish","type":"page","link":"https:\/\/aplicaexcelcontable.com\/blog\/resaltar-filas-alternas","title":{"rendered":"Resaltar Filas alternas"},"content":{"rendered":"<h1 style=\"text-align: center;\"><strong>VIDEO 4 &#8211; Como Resaltar Filas Alternas con FC<\/strong><\/h1>\n<p style=\"text-align: justify;\">Comenzamos con los pasos de Como Resaltar Filas Alternas con Formato Condiciona, mira el Video:<\/p>\n<p><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/10\/Practica-Resaltar-Filas-Alternas.xlsx\" target=\"_blank\" rel=\"noopener\"><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/10\/Practica-Resaltar-Filas-Alternas.xlsx\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\"><em><strong>Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p>\n<p style=\"\">Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p>\n<p style=\"text-align: justify;\">Bienvenido a este video 4 del Mini Curso de Formato Condicional.<\/p>\n<p style=\"text-align: justify;\">En este video vamos a ver el primer truco de Formato Condicional y se trata de los pasos de Como Resaltar Filas Alternas.Estas listo para aprender y aplicar el nuevo truco?Comencemos:<\/p>\n<p><strong><\/p>\n<h1 dir=\"ltr\" style=\"text-align: center;\">Pasos para Resaltar Filas Alternas<\/h1>\n<p><\/strong><\/p>\n<p>Como Primer paso te invito a que descargues el archivo excel que te he dejado justo debajo de este video, para que puedas practicar todos los paso que voy a compartirte a continuaci\u00f3n.Ya descargaste el Archivo?Muy bien, ahora abrelo y comencemos con los pasos de Resaltar Filas Alternas en Excel.Por lo tanto, Sigamos los siguientes pasos:<\/p>\n<ul>\n<li><strong><\/strong><strong>Seleccionamos de la B18 hasta la Q18 y desplegamos formato condicional.<\/strong><\/li>\n<li><strong>Dentro de este pulsamos clic en Nueva regla<\/strong><\/li>\n<li><strong>Seleccionamos la opcion: \u201cUtilice una Formula que determine las celdas para aplicar Formato\u201d.<\/strong><\/li>\n<li><strong>Nos ubicamos donde dice: \u201cDar Formato a los Valores Donde esta Formula sea Verdadera\u201d.<\/strong><strong><\/strong><strong><\/strong><\/li>\n<\/ul>\n<ul>\n<li><strong><\/strong><strong>Escribimos la siguiente Formula dentro del cuadro de texto: =RESIDUO(FILA();2)=0.<\/strong><\/li>\n<li><strong>Ahora, pulsamos clic en el boton formato y te ubicas en la seccion Relleno dentro de la ventana.<\/strong><\/li>\n<li><strong>Seleccionamos el color de tu preferencia, en este caso voy a escoger amarrillo, aceptamos y nuevamente aceptar.<\/strong><\/li>\n<\/ul>\n<p><span style=\"color: rgb(8, 1, 1);\">En Conclusi\u00f3n, puedes notar que las filas se resaltan alternamente.Algo muy importante que debes de tomar en cuenta al escribir Formulas son los separadores.<\/span><\/p>\n<h1 style=\"text-align: center;\">Sistema Contable V9.0<\/h1>\n<p><span style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/sistema-contable-en-excel-v9\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" alt=\"Resaltar Filas alternas\" width=\"219\" height=\"109\" title=\"b48700d0b785828232c7626c68dd6c28.png\" src=\"\/\/i.pinimg.com\/originals\/b4\/87\/00\/b48700d0b785828232c7626c68dd6c28.png\" style=\"aspect-ratio: auto 431 \/ 214;\" data-width=\"219\" data-height=\"109\" data-init-width=\"431\" data-init-height=\"214\" loading=\"lazy\"><\/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<h1 style=\"text-align: center;\">Tipos de Separadores en Excel<\/h1>\n<p style=\"text-align: justify;\">En Excel existe dos tipos de separador de forma predeterminado: El pundo y coma y la coma.Para identificar que separador utiliza tu Excel, tan solo escribe una formula y dentro del cuadrito de ayuda de Formula, podras notar el tipo de separado que utilizas, en mi caso caso es el punto y coma.Para otras compuntadoras puede ser la coma, siempre verifica e identifica tu separador al escribir formulas.Y es importante que tomes en cuenta el tema de los sepadores, ya que si escribes el separador incorrecto, entonces la formula no te funcionara, mucho menos el formato condicional.<\/p>\n<p style=\"text-align: justify;\">Nos vemos en el Proximo video donde vamos a ver: Como Resaltar Columnas Alternas con Formato Condicional.<\/p>\n<p style=\"text-align: justify;\">Que tal te parecio 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 4 &#8211; Como Resaltar Filas Alternas con FC Comenzamos con los pasos de Como Resaltar Filas Alternas con Formato Condiciona, mira el Video: Haz clic para descargar el archivo excel Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica. Bienvenido a este video 4 del [&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-15f6e2562cd\" style=\"--tcb-col-el-width: 1009;\"><div class=\"tcb-flex-row tcb-resized tcb--cols--2\" data-css=\"tve-u-15f6e2562cc\"><div class=\"tcb-flex-col\" data-css=\"tve-u-15f6e2562ea\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\"><h1 class=\"\" data-css=\"tve-u-15f6e2562e8\" style=\"text-align: center;\"><strong>VIDEO 4 - Como Resaltar Filas Alternas con FC<\/strong><\/h1><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-15f6e2562dc\" style=\"text-align: justify;\">Comenzamos con los pasos de Como Resaltar Filas Alternas con Formato Condiciona, mira el Video:<\/p><\/div><div class=\"thrv_wrapper thrv-button tve_ea_thrive_lightbox\" data-css=\"tve-u-16918ea8fe3\" 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\" data-tcb-events=\"__TCB_EVENT_[{&quot;config&quot;:{&quot;l_anim&quot;:&quot;instant&quot;,&quot;l_id&quot;:&quot;41351&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 tve-elem-default-pad\" data-css=\"tve-u-18d61bcb32d\" style=\"\" id=\"descarga\">\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-18d61bcb32e\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d61bcb32b\"><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-18d61bcb32c\" style=\"--tcb-col-el-width: 663.844;\"><div class=\"tcb-flex-row v-2 tcb-resized tcb--cols--2\"><div class=\"tcb-flex-col\" data-css=\"tve-u-18d61bcb327\" style=\"\"><div class=\"tcb-col\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/10\/Practica-Resaltar-Filas-Alternas.xlsx\" target=\"_blank\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-18d61bcb326\" style=\"\" data-link-wrap=\"true\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 384 512\" data-id=\"icon-file-excel-solid\" data-name=\"\" style=\"\"><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><\/svg><\/div><\/a><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-18d61bcb328\" style=\"\"><div class=\"tcb-col\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: center;\" data-css=\"tve-u-18d61bcb329\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/10\/Practica-Resaltar-Filas-Alternas.xlsx\" target=\"_blank\" class=\"\" style=\"outline: none;\"><em><strong>Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p><\/div><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p><\/div><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root tve_evt_manager_listen tve_et_tve-viewport tve_ea_thrive_animation tve_anim_slide_right\" data-css=\"tve-u-18d61bcb32f\" style=\"\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;slide_right&quot;,&quot;loop&quot;:1},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\"><svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-hand-point-up-solid\" data-name=\"\" style=\"\"><path d=\"M135.652 0c23.625 0 43.826 20.65 43.826 44.8v99.851c17.048-16.34 49.766-18.346 70.944 6.299 22.829-14.288 53.017-2.147 62.315 16.45C361.878 158.426 384 189.346 384 240c0 2.746-.203 13.276-.195 16 .168 61.971-31.065 76.894-38.315 123.731C343.683 391.404 333.599 400 321.786 400H150.261l-.001-.002c-18.366-.011-35.889-10.607-43.845-28.464C93.421 342.648 57.377 276.122 29.092 264 10.897 256.203.008 242.616 0 224c-.014-34.222 35.098-57.752 66.908-44.119 8.359 3.583 16.67 8.312 24.918 14.153V44.8c0-23.45 20.543-44.8 43.826-44.8zM136 416h192c13.255 0 24 10.745 24 24v48c0 13.255-10.745 24-24 24H136c-13.255 0-24-10.745-24-24v-48c0-13.255 10.745-24 24-24zm168 28c-11.046 0-20 8.954-20 20s8.954 20 20 20 20-8.954 20-20-8.954-20-20-20z\"><\/path><\/svg><\/div><\/div><\/div><\/div><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15f6e2562c8\" style=\"\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15f6e2562ec\"><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width: 701.844;\"><div class=\"tcb-flex-row tcb--cols--1\" data-css=\"tve-u-15f6e2562ca\"><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-15f6e2562df\" style=\"text-align: justify;\">Bienvenido a este video 4 del Mini Curso de Formato Condicional.<\/p><p data-css=\"tve-u-15f6e2562df\" style=\"text-align: justify;\">En este video vamos a ver el primer truco de Formato Condicional y se trata de los pasos de Como Resaltar Filas Alternas.<br><br>Estas listo para aprender y aplicar el nuevo truco?<br><br>Comencemos:<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-15f6e256301\"><strong class=\"\"><h1 data-css=\"tve-u-15f6e256303\" dir=\"ltr\" style=\"text-align: center;\">Pasos para Resaltar Filas Alternas<\/h1><\/strong><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15fa801a93f\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15fa801a96b\"><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width: 701.844;\"><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\" data-css=\"tve-u-17cf1c821ef\" style=\"\"><p data-css=\"tve-u-15fa801a93c\">Como Primer paso te invito a que descargues el archivo excel que te he dejado justo debajo de este video, para que puedas practicar todos los paso que voy a compartirte a continuaci\u00f3n.<br><br>Ya descargaste el Archivo?<br><br>Muy bien, ahora abrelo y comencemos con los pasos de Resaltar Filas Alternas en Excel.<br><br>Por lo tanto, Sigamos los siguientes pasos:<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15fa80c451c\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15fa801a96b\"><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width: 701.844;\"><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\"><ul class=\"\"><li class=\"\" data-css=\"tve-u-15fa801a93c\"><strong><\/strong><strong>Seleccionamos de la B18 hasta la Q18 y desplegamos formato condicional.<\/strong><\/li><li class=\"\" data-css=\"tve-u-15fa801a93c\"><strong>Dentro de este pulsamos clic en Nueva regla<\/strong><\/li><li class=\"\" data-css=\"tve-u-15fa801a93c\"><strong>Seleccionamos la opcion: \u201cUtilice una Formula que determine las celdas para aplicar Formato\u201d.<\/strong><\/li><li class=\"\" data-css=\"tve-u-15fa801a93c\"><strong>Nos ubicamos donde dice: \u201cDar Formato a los Valores Donde esta Formula sea Verdadera\u201d.<\/strong><strong><\/strong><strong><\/strong><br><\/li><\/ul><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15f6e2562c5\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15f6e256305\"><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width: 701.844;\"><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\"><ul class=\"\"><li class=\"\" data-css=\"tve-u-15f6e3a64eb\"><strong><\/strong><strong>Escribimos la siguiente Formula dentro del cuadro de texto: =RESIDUO(FILA();2)=0.<\/strong><\/li><li class=\"\" data-css=\"tve-u-15f6e3a64eb\"><strong>Ahora, pulsamos clic en el boton formato y te ubicas en la seccion Relleno dentro de la ventana.<\/strong><\/li><li class=\"\" data-css=\"tve-u-15f6e3a64eb\"><strong>Seleccionamos el color de tu preferencia, en este caso voy a escoger amarrillo, aceptamos y nuevamente aceptar.<\/strong><\/li><\/ul><p><span data-css=\"tve-u-15f6e3d61e1\" style=\"color: rgb(8, 1, 1);\">En Conclusi\u00f3n, puedes notar que las filas se resaltan alternamente.<br><br>Algo muy importante que debes de tomar en cuenta al escribir Formulas son los separadores.<\/span><\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-15f6e2562e9\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-15f6e2562e0\"><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15fa7efc689\"><div class=\"tve-content-box-background\" data-css=\"tve-u-15fa7efc697\"><\/div><div class=\"tve-cb tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-15fa7efc68d\" data-tag=\"h1\"><h1 class=\"\" data-css=\"tve-u-15fa7efc698\" style=\"text-align: center;\">Sistema Contable V9.0<\/h1><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-15fa7efc695\" style=\"\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/sistema-contable-en-excel-v9\" target=\"_blank\"><img decoding=\"async\" class=\"tve_image\" alt=\"Resaltar Filas alternas\" width=\"219\" height=\"109\" title=\"b48700d0b785828232c7626c68dd6c28.png\" src=\"\/\/i.pinimg.com\/originals\/b4\/87\/00\/b48700d0b785828232c7626c68dd6c28.png\" style=\"aspect-ratio: auto 431 \/ 214;\" data-width=\"219\" data-height=\"109\" data-init-width=\"431\" data-init-height=\"214\" loading=\"lazy\"><\/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-15fa7efc68e\" data-icons-size=\"18\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-15fa7efc69c\"><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-15fa7efc692\"><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-15fa7efc6a0\">Genera Tus Cuentas Mayores<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-15fa7efc69f\"><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-15fa7efc691\"><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-15fa7efc69e\"><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-15fa7efc690\"><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-15fa7efc69d\"><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-15fa7efc694\"><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-15fa7efc693\">Lleva el Control de Tus Cuentas por Cobrar y Pagar<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv-button\" data-css=\"tve-u-15fa7efc68c\"> <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/sistema-contable-en-excel-v9\" class=\"tcb-button-link\" target=\"_blank\"> <span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\" data-css=\"tve-u-15fa7efc68b\"><strong>Clic aqui para mas detalles \u2192<\/strong><\/span><\/span> <\/a><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width: 1009;\"><div class=\"tcb-flex-row tcb--cols--1\"><div class=\"tcb-flex-col\" data-css=\"tve-u-15f51534824\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-15f6e2562fd\" data-tag=\"h1\"><h1 data-css=\"tve-u-15f6e2562fe\" style=\"text-align: center;\" class=\"\">Tipos de Separadores en Excel<\/h1><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" data-css=\"tve-u-15fa80bfedb\"><p data-css=\"tve-u-15f6e2562ef\" style=\"text-align: justify;\">En Excel existe dos tipos de separador de forma predeterminado: El pundo y coma y la coma.<br><br>Para identificar que separador utiliza tu Excel, tan solo escribe una formula y dentro del cuadrito de ayuda de Formula, podras notar el tipo de separado que utilizas, en mi caso caso es el punto y coma.<br><br>Para otras compuntadoras puede ser la coma, siempre verifica e identifica tu separador al escribir formulas.<br><br>Y es importante que tomes en cuenta el tema de los sepadores, ya que si escribes el separador incorrecto, entonces la formula no te funcionara, mucho menos el formato condicional.<\/p><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15f6e2562f3\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15f6e256304\"><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width: 1007;\"><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-15f6e2562fa\" style=\"text-align: justify;\">Nos vemos en el Proximo video donde vamos a ver: Como Resaltar Columnas Alternas con Formato Condicional.<\/p><p data-css=\"tve-u-15f6e2562f5\" style=\"text-align: justify;\">Que tal te parecio el video? Te gusto?<\/p><p data-css=\"tve-u-15f6e2562f5\" 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-15f6e2562f2\"><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\/resaltar-filas-alternas\" 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-15f6e2562ee\"><p data-css=\"tve-u-15f6e2562f1\" 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-15f6e2562f1\" style=\"text-align: justify;\">Cualquier duda o pregunta, tan solo escribenos en el chat.<\/p><p data-css=\"tve-u-15f6e2562f1\" style=\"text-align: justify;\">Saludos,<\/p><p data-css=\"tve-u-15f6e2562f1\" style=\"text-align: justify;\"><strong>Roger Perez - Aplica Excel Contable<\/strong><\/p><p data-css=\"tve-u-15f6e2562f0\"><br><\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-15fa80bfedb\"] { margin-bottom: -72px !important; }[data-css=\"tve-u-15f6e3d61e1\"] { color: rgb(8, 1, 1) !important; }:not(#tve) [data-css=\"tve-u-15f6e3a64eb\"] { color: rgb(6, 1, 1) !important; }[data-css=\"tve-u-15f6e2562c5\"] { margin-top: -24px !important; }[data-css=\"tve-u-15f6e2562c8\"] { margin-top: 0px !important; padding-top: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-15f6e2562ca\"] { padding-top: 16px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-15f6e2562cc\"] { padding-top: 16px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-15f6e2562cd\"] { margin-top: -1px !important; }:not(#tve) [data-css=\"tve-u-15f6e2562dc\"] { color: rgb(6, 2, 2) !important; }:not(#tve) [data-css=\"tve-u-15f6e2562df\"] { color: rgb(8, 3, 3) !important; }[data-css=\"tve-u-15f6e2562e0\"] { border: none; border-radius: 3px; overflow: hidden; margin-top: -26px !important; }:not(#tve) [data-css=\"tve-u-15f6e2562e8\"] { font-size: 27px !important; color: rgb(244, 2, 2) !important; }[data-css=\"tve-u-15f6e2562e9\"] { max-width: 29.8%; }[data-css=\"tve-u-15f6e2562ea\"] { max-width: 70.1996%; }[data-css=\"tve-u-15f6e2562ec\"] p { margin: 0px 0px 15px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e2562ec\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e2562ec\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e2562ec\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e2562ec\"] address { line-height: 1.45em; }[data-css=\"tve-u-15f6e2562ee\"] { margin-top: -34px !important; }:not(#tve) [data-css=\"tve-u-15f6e2562ef\"] { color: rgb(6, 4, 4) !important; }:not(#tve) [data-css=\"tve-u-15f6e2562f0\"] { color: rgb(7, 4, 4) !important; }:not(#tve) [data-css=\"tve-u-15f6e2562f1\"] { color: rgb(7, 4, 4) !important; }[data-css=\"tve-u-15f6e2562f2\"] { float: none; margin-top: -27px !important; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-15f6e2562f3\"] { margin-top: 27px !important; }:not(#tve) [data-css=\"tve-u-15f6e2562f5\"] { color: rgb(6, 2, 2) !important; }:not(#tve) [data-css=\"tve-u-15f6e2562fa\"] { color: rgb(6, 2, 2) !important; }[data-css=\"tve-u-15f6e2562fd\"] { margin-top: -40px !important; }:not(#tve) [data-css=\"tve-u-15f6e2562fe\"] { font-size: 25px !important; color: rgb(12, 26, 249) !important; }[data-css=\"tve-u-15f6e256301\"] { margin-top: -38px !important; padding-bottom: 0px !important; padding-top: 5px !important; margin-bottom: 51px !important; }:not(#tve) [data-css=\"tve-u-15f6e256303\"] { font-size: 25px !important; color: rgb(249, 8, 8) !important; }[data-css=\"tve-u-15f6e256304\"] p { margin: 0px 0px 15px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e256304\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e256304\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e256304\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e256304\"] address { line-height: 1.45em; }[data-css=\"tve-u-15f6e256305\"] p { margin: 0px 0px 15px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e256305\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e256305\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e256305\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f6e256305\"] address { line-height: 1.45em; }[data-css=\"tve-u-15fa7efc689\"] { margin-top: 87px !important; }:not(#tve) [data-css=\"tve-u-15fa7efc68b\"] { color: rgb(7, 3, 3) !important; }[data-css=\"tve-u-15fa7efc68c\"] .tcb-button-link { background-image: none !important; background-color: rgb(242, 208, 24) !important; }[data-css=\"tve-u-15fa7efc68d\"] { margin-top: 8px !important; padding-left: 8px !important; }[data-css=\"tve-u-15fa7efc68e\"] { padding-left: 0px !important; margin-left: 5px !important; }:not(#tve) [data-css=\"tve-u-15fa7efc68e\"] p, :not(#tve) [data-css=\"tve-u-15fa7efc68e\"] li, :not(#tve) [data-css=\"tve-u-15fa7efc68e\"] blockquote, :not(#tve) [data-css=\"tve-u-15fa7efc68e\"] address { color: rgb(3, 1, 1); font-size: 14px; }[data-css=\"tve-u-15fa7efc690\"] { color: rgb(22, 150, 46); }[data-css=\"tve-u-15fa7efc691\"] { color: rgb(22, 150, 46); }[data-css=\"tve-u-15fa7efc692\"] { color: rgb(22, 150, 46); }:not(#tve) [data-css=\"tve-u-15fa7efc693\"] { font-size: 14px !important; color: rgb(7, 2, 2) !important; }[data-css=\"tve-u-15fa7efc693\"] { line-height: 1.4em !important; }[data-css=\"tve-u-15fa7efc694\"] { color: rgb(22, 150, 46); }[data-css=\"tve-u-15fa7efc695\"] + div { clear: none; }[data-css=\"tve-u-15fa7efc695\"] { float: none; margin-left: auto; margin-right: auto; width: 219px; margin-top: 0px !important; }[data-css=\"tve-u-15fa7efc697\"] { border: 3px solid rgb(9, 6, 245) !important; }:not(#tve) [data-css=\"tve-u-15fa7efc698\"] { font-size: 23px !important; color: rgb(246, 14, 45) !important; }:not(#tve) [data-css=\"tve-u-15fa801a93c\"] { color: rgb(6, 1, 1) !important; }[data-css=\"tve-u-15fa801a93f\"] { margin-top: -100px !important; }[data-css=\"tve-u-15fa801a96b\"] p { margin: 0px 0px 15px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-15fa801a96b\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-15fa801a96b\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-15fa801a96b\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-15fa801a96b\"] address { line-height: 1.45em; }[data-css=\"tve-u-15fa80c451c\"] { margin-top: -47px !important; margin-bottom: -28px !important; }[data-css=\"tve-u-16918ea8fe3\"] .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-16918ea8fe3\"]:hover .tcb-button-link { background-color: rgb(218, 113, 8) !important; }:not(#tve) [data-css=\"tve-u-16918ea8fe3\"] .tcb-button-link { line-height: 1.2em; font-size: 24px; }[data-css=\"tve-u-16918ea8fe3\"] { margin-top: 0px !important; margin-bottom: 20px !important; }[data-css=\"tve-u-17cf1c821ef\"] { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-17729e928e3\"] .post-wrapper.thrv_wrapper { width: calc(50% - 3.5px); }.tcb-post-list[data-css=\"tve-u-17729e928e3\"] .post-wrapper.thrv_wrapper:nth-child(n+3) { margin-top: 10px !important; }.tcb-post-list[data-css=\"tve-u-17729e928e3\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+3)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-17729e928e3\"] .post-wrapper.thrv_wrapper:not(:nth-child(2n)) { margin-right: 7px !important; }.tcb-post-list[data-css=\"tve-u-17729e928e3\"] .post-wrapper.thrv_wrapper:nth-child(2n) { margin-right: 0px !important; }[data-css=\"tve-u-18d61bcb326\"] { font-size: 84px; margin-left: auto; margin-right: auto; --tcb-local-color-icon: rgb(4, 228, 38); --tcb-local-color-var: rgb(4, 228, 38); --tve-icon-size: 84px; --tcb-icon-rotation-angle: -22deg; width: 84px; height: 84px; }:not(#tve) [data-css=\"tve-u-18d61bcb326\"] > :first-child { color: rgb(4, 228, 38); --tve-applied-color: rgb(4, 228, 38); }[data-css=\"tve-u-18d61bcb327\"] { max-width: 18.1%; }[data-css=\"tve-u-18d61bcb328\"] { max-width: 81.9%; }:not(#tve) [data-css=\"tve-u-18d61bcb329\"] { font-size: 21px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d61bcb32b\"] h6 { color: var(--tve-color, rgb(0, 3, 6)); --tve-applied-color: var$(--tve-color, rgb(0, 3, 6)); --tcb-applied-color: rgb(0, 3, 6); }[data-css=\"tve-u-18d61bcb32b\"] { --tve-color: rgb(0, 3, 6); --tve-applied---tve-color: rgb(0, 3, 6); text-align: justify; }[data-css=\"tve-u-18d61bcb32b\"] p { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-18d61bcb32c\"] { margin-bottom: 0px !important; margin-top: 0px !important; }[data-css=\"tve-u-18d61bcb32d\"] { margin-top: 0px !important; padding-top: 0px !important; padding-bottom: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-18d61bcb32e\"] { --tve-border-width: 6px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; border: 6px dashed rgb(234, 194, 13) !important; --tve-applied-border: 6px dashed rgb(234, 194, 13) !important; }[data-css=\"tve-u-18d61bcb32f\"] { font-size: 60px; --tcb-local-color-icon: rgb(227, 12, 38); --tcb-local-color-var: rgb(227, 12, 38); --tve-icon-size: 60px; float: none; z-index: 3; position: relative; --tve-alignment: center; margin: -109px auto 0px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-18d61bcb32f\"] > :first-child { color: rgb(227, 12, 38); --tve-applied-color: rgb(227, 12, 38); }}@media (max-width: 1023px){:not(#tve) [data-css=\"tve-u-15fa7efc68b\"] { font-size: 12px !important; }[data-css=\"tve-u-15fa7efc69c\"] { max-width: 97px; }[data-css=\"tve-u-15fa7efc69d\"] { max-width: 95px; }[data-css=\"tve-u-15fa7efc694\"] { 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-15fa7efc69e\"] { max-width: 97px; margin-right: -9px !important; padding-right: 0px !important; }[data-css=\"tve-u-15fa7efc690\"] { 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-15fa7efc69f\"] { max-width: 101px; margin-right: -16px !important; padding-right: 0px !important; padding-left: 14px !important; margin-left: -2px !important; }[data-css=\"tve-u-15fa7efc691\"] { font-size: 18px; width: 18px; height: 18px; margin-right: 56px !important; margin-left: -13px !important; padding-left: 0px !important; }[data-css=\"tve-u-15fa7efc692\"] { 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-15fa7efc6a0\"] { font-size: 13px !important; }:not(#tve) [data-css=\"tve-u-15fa7efc698\"] { font-size: 13px !important; }[data-css=\"tve-u-15fa7efc695\"] { 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-26512","page","type-page","status-publish","hentry","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/pages\/26512","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=26512"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/pages\/26512\/revisions"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=26512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}