{"id":26740,"date":"2017-11-09T06:31:26","date_gmt":"2017-11-09T12:31:26","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?page_id=26740"},"modified":"2022-01-22T22:38:22","modified_gmt":"2022-01-23T04:38:22","slug":"ejemplo-resaltar-omisiones","status":"publish","type":"page","link":"https:\/\/aplicaexcelcontable.com\/blog\/ejemplo-resaltar-omisiones","title":{"rendered":"Ejemplo resaltar omisiones"},"content":{"rendered":"<h1 style=\"text-align: center;\"><strong>VIDEO 10 &#8211; Ejemplo Resaltar omisiones con FC<\/strong><\/h1>\n<p style=\"text-align: justify;\">Comenzamos con el ejemplo Resaltar Omisiones con Formato Condicional, mira el Video:<\/p>\n<p><span style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Practica-Resaltar-Omisiones-en-Excel.xlsx\"><img decoding=\"async\" loading=\"lazy\" alt=\"\" width=\"64\" height=\"64\" title=\"33290234771_090c549156_s.jpg\" src=\"\/\/farm3.staticflickr.com\/2818\/33290234771_090c549156_s.jpg\" style=\"\"><\/a><\/span><\/p>\n<h1><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Practica-Resaltar-Omisiones-en-Excel.xlsx\" style=\"outline: none;\">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 10 del Mini Curso de Formato Condicional.<\/p>\n<p style=\"text-align: justify;\">En este video vamos a ver el truco n\u00famero 7 de Formato Condicional y se trata de los pasos de Como Resaltar omisiones con Formato Condicional.<\/p>\n<p style=\"text-align: justify;\">Est\u00e1s listo para aplicar este nuevo truco?<\/p>\n<p style=\"text-align: justify;\">Comencemos:<\/p>\n<p><strong><\/p>\n<h1 dir=\"ltr\" style=\"text-align: center;\">Pasos para Resaltar omisiones en Excel<\/h1>\n<p><\/strong><\/p>\n<p>Como primer paso, vamos abrir el archivo de pr\u00e1ctica, si a un no lo tienes, te invito a que lo descargues, te lo he dejado justo debajo de este video.<\/p>\n<p>Ya lo descargaste?<\/p>\n<p>Veamos el primer paso:<\/p>\n<ul>\n<li><strong>Para comenzar seleccionamos la celda D7 hasta la D39.<\/strong><\/li>\n<li><strong>En seguida, desplegamos formato condicional y seleccionamos nueva regla.<\/strong><\/li>\n<li><strong>Por lo tanto, dentro de este seleccionamos la opcion: \u201cUtilice una Formula que determine las celdas para aplicar formato\u201d.<\/strong><\/li>\n<li><strong>En el cuadro de texto escribimos la siguiente formula: =CONTAR.SI($H$7:$I$19;$J7)&lt;1 y pulsamos clic en formato.<\/strong><\/li>\n<li><strong>Dentro de este, nos ubicamos en la secci\u00f3n fuente y seleccionamos el estilo negrita.<\/strong><\/li>\n<li><strong>Ahora nos ubicamos en la secci\u00f3n relleno y le aplicamos el color de relleno de tu preferencia, en este caso voy a seleccionar amarrillo, aceptamos y nuevamente aceptar.<\/strong><\/li>\n<\/ul>\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=\"Ejemplo Resaltar Omisiones\" 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>En conclusion, ahora puedes hacer una prueba,&nbsp;puedes notar como se resalta autom\u00e1ticamente las celdas que contiene el valor que no aparecen en la lista A y B.<\/p>\n<p>Por lo tanto:<\/p>\n<p>Si agregamos un valor mas, y como este no aparece en la lista A y B, se resalta automaticame.<\/p>\n<p style=\"text-align: justify;\">Nos vemos en el Proximo video donde vamos a ver: <strong>Como crear cuadros de mando con Formato Condicional.<\/strong><\/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 10 &#8211; Ejemplo Resaltar omisiones con FC Comenzamos con el ejemplo Resaltar Omisiones con Formato Condicional, mira el Video: Haz clic aqu\u00ed para Descargar el Archivo Haz clic en el enlace o bien en la imagen para descargar el archivo de Practica de Como Resaltar Filas Alternas. Bienvenido a este video 10 del Mini [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":47113,"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-15fa0bba5c2\" style=\"--tcb-col-el-width:1009;\"><div class=\"tcb-flex-row tcb-resized tcb--cols--2\" data-css=\"tve-u-15fa0bba5c0\"><div class=\"tcb-flex-col\" data-css=\"tve-u-15fa0bba5d7\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\"><h1 data-css=\"tve-u-15fa0bba5d5\" style=\"text-align: center;\" class=\"\"><strong>VIDEO 10 - Ejemplo Resaltar omisiones con FC<\/strong><\/h1><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-15fa0bba5d0\" style=\"text-align: justify;\">Comenzamos con el ejemplo Resaltar Omisiones con Formato Condicional, mira el Video:<\/p><\/div><div class=\"thrv_wrapper thrv-button tve_ea_thrive_lightbox\" data-css=\"tve-u-1691ae3fcac\" 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;41359&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-15fa0bba5ea\"><div class=\"tve-content-box-background\" data-css=\"tve-u-15fa0bba5f1\" 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:692.844;\"><div class=\"tcb-flex-row tcb-resized tcb--cols--2\" data-css=\"tve-u-15fa0bba5ed\"><div class=\"tcb-flex-col\" data-css=\"tve-u-15fa0bba5ec\" style=\"\"><div class=\"tcb-col\"><div class=\"tcb-clear\" data-css=\"tve-u-15fa0bba5ef\"><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-15fa0bba5f0\" data-clear=\"both\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Practica-Resaltar-Omisiones-en-Excel.xlsx\"><img loading=\"lazy\" class=\"tve_image\" alt=\"\" width=\"64\" height=\"64\" title=\"33290234771_090c549156_s.jpg\" src=\"\/\/farm3.staticflickr.com\/2818\/33290234771_090c549156_s.jpg\" style=\"\"><\/a><\/span><\/div><\/div><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-15fa0bba5eb\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-15fa0bba5e9\"><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-15fa0bba5e7\" data-tag=\"h1\"><h1 data-css=\"tve-u-15fa0bba5ee\" class=\"\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Practica-Resaltar-Omisiones-en-Excel.xlsx\" class=\"tve-froala\" style=\"outline: none;\">Haz clic aqu\u00ed para Descargar el Archivo <\/a><\/h1><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" data-css=\"tve-u-15fa0bba5e6\"><p data-css=\"tve-u-15fa0bba5e8\"><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-15fa0bba5bd\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15fa0bba5d8\"><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-15fa0bba5be\"><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-15fa0bba5d2\" style=\"text-align: justify;\">Bienvenido a este video 10 del Mini Curso de Formato Condicional.<\/p><p data-css=\"tve-u-15fa0bba5d2\" style=\"text-align: justify;\">En este video vamos a ver el truco n\u00famero 7 de Formato Condicional y se trata de los pasos de Como Resaltar omisiones con Formato Condicional.<\/p><p data-css=\"tve-u-15fa0bba5d2\" style=\"text-align: justify;\">Est\u00e1s listo para aplicar este nuevo truco?<\/p><p data-css=\"tve-u-15fa0bba5d2\" style=\"text-align: justify;\">Comencemos:<\/p><\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-15fa0bba5e2\"><strong class=\"\"><h1 data-css=\"tve-u-15fa0bba5e3\" dir=\"ltr\" style=\"text-align: center;\">Pasos para Resaltar omisiones en Excel<\/h1><\/strong><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" data-css=\"tve-u-15fa0bba5b9\"><p data-css=\"tve-u-15fa0bba5bb\">Como primer paso, vamos abrir el archivo de pr\u00e1ctica, si a un no lo tienes, te invito a que lo descargues, te lo he dejado justo debajo de este video.<\/p><p data-css=\"tve-u-15fa0bba5bb\">Ya lo descargaste?<\/p><p data-css=\"tve-u-15fa0bba5bb\">Veamos el primer paso:<\/p><ul class=\"\"><li class=\"\" data-css=\"tve-u-15fa0bba5bb\"><strong>Para comenzar seleccionamos la celda D7 hasta la D39.<\/strong><\/li><li class=\"\" data-css=\"tve-u-15fa0bba5bb\"><strong>En seguida, desplegamos formato condicional y seleccionamos nueva regla.<\/strong><\/li><li class=\"\" data-css=\"tve-u-15fa0bba5bb\"><strong>Por lo tanto, dentro de este seleccionamos la opcion: \u201cUtilice una Formula que determine las celdas para aplicar formato\u201d.<\/strong><\/li><li class=\"\" data-css=\"tve-u-15fa0bba5bb\"><strong>En el cuadro de texto escribimos la siguiente formula: =CONTAR.SI($H$7:$I$19;$J7)&lt;1 y pulsamos clic en formato.<\/strong><\/li><li class=\"\" data-css=\"tve-u-15fa0bba5bb\"><strong>Dentro de este, nos ubicamos en la secci\u00f3n fuente y seleccionamos el estilo negrita.<\/strong><\/li><li class=\"\" data-css=\"tve-u-15fa0bba5bb\"><strong>Ahora nos ubicamos en la secci\u00f3n relleno y le aplicamos el color de relleno de tu preferencia, en este caso voy a seleccionar amarrillo, aceptamos y nuevamente aceptar.<\/strong><\/li><\/ul><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-15fa0bba5d6\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-15fa0bba5d3\"><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15fa7d19f54\"><div class=\"tve-content-box-background\" data-css=\"tve-u-15fa7d19f61\"><\/div><div class=\"tve-cb tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-15fa7d19f58\" data-tag=\"h1\"><h1 data-css=\"tve-u-15fa7d19f62\" style=\"text-align: center;\" class=\"\">Sistema Contable V6.0<\/h1><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-15fa7d19f60\" style=\"\"><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=\"Ejemplo Resaltar Omisiones\" 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-15fa7d19f59\" data-icons-size=\"18\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-15fa7d19f66\"><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-15fa7d19f5d\"><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-15fa7d19f6b\">Genera Tus Cuentas Mayores<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-15fa7d19f6a\"><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-15fa7d19f5c\"><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-15fa7d19f69\"><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-15fa7d19f5a\"><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-15fa7d19f68\"><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-15fa7d19f5f\"><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-15fa7d19f5e\">Lleva el Control de Tus Cuentas por Cobrar y Pagar<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv-button\" data-css=\"tve-u-15fa7d19f57\"> <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-15fa7d19f56\"><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;\"><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_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-15fa0bba5df\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15fa0bba5e4\"><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-15fa0bba5b8\">En conclusion, ahora puedes hacer una prueba,&nbsp;puedes notar como se resalta autom\u00e1ticamente las celdas que contiene el valor que no aparecen en la lista A y B.<\/p><p data-css=\"tve-u-15fa0bba5b8\">Por lo tanto:<\/p><p data-css=\"tve-u-15fa0bba5b8\">Si agregamos un valor mas, y como este no aparece en la lista A y B, se resalta automaticame.<\/p><p data-css=\"tve-u-15fa0bba5e1\" style=\"text-align: justify;\">Nos vemos en el Proximo video donde vamos a ver: <strong>Como crear cuadros de mando con Formato Condicional.<\/strong><\/p><p data-css=\"tve-u-15fa0bba5f4\" style=\"text-align: justify;\">Que tal te parecio el video? Te gusto?<\/p><p data-css=\"tve-u-15fa0bba5e0\" 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-15fa0bba5de\"><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\/ejemplo-resaltar-omisiones\" 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-15fa0bba5db\"><p data-css=\"tve-u-15fa0bba5dd\" 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-15fa0bba5dd\" style=\"text-align: justify;\">Cualquier duda o pregunta, tan solo escribenos en el chat.<\/p><p data-css=\"tve-u-15fa0bba5dd\" style=\"text-align: justify;\">Saludos,<\/p><p data-css=\"tve-u-15fa0bba5dd\" style=\"text-align: justify;\"><strong>Roger Perez - Aplica Excel Contable<\/strong><\/p><p data-css=\"tve-u-15fa0bba5dc\"><br><\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div>","tve_custom_css":"@media (min-width: 300px){:not(#tve) [data-css=\"tve-u-15fa0bba5b8\"] { color: rgb(6, 1, 1) !important; }[data-css=\"tve-u-15fa0bba5b9\"] { margin-top: -54px !important; }:not(#tve) [data-css=\"tve-u-15fa0bba5bb\"] { color: rgb(6, 1, 1) !important; }[data-css=\"tve-u-15fa0bba5bd\"] { margin-top: 20px !important; padding-top: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-15fa0bba5be\"] { padding-top: 16px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-15fa0bba5c0\"] { padding-top: 16px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-15fa0bba5c2\"] { margin-top: -1px !important; }:not(#tve) [data-css=\"tve-u-15fa0bba5d0\"] { color: rgb(6, 2, 2) !important; }:not(#tve) [data-css=\"tve-u-15fa0bba5d2\"] { color: rgb(8, 3, 3) !important; }[data-css=\"tve-u-15fa0bba5d3\"] { margin-top: -16px !important; }:not(#tve) [data-css=\"tve-u-15fa0bba5d5\"] { font-size: 27px !important; color: rgb(244, 2, 2) !important; }[data-css=\"tve-u-15fa0bba5d6\"] { max-width: 29.8%; }[data-css=\"tve-u-15fa0bba5d7\"] { max-width: 70.2%; }[data-css=\"tve-u-15fa0bba5d8\"] p { margin: 0px 0px 15px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-15fa0bba5d8\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-15fa0bba5d8\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-15fa0bba5d8\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-15fa0bba5d8\"] address { line-height: 1.45em; }[data-css=\"tve-u-15fa0bba5db\"] { margin-top: -34px !important; }:not(#tve) [data-css=\"tve-u-15fa0bba5dc\"] { color: rgb(7, 4, 4) !important; }:not(#tve) [data-css=\"tve-u-15fa0bba5dd\"] { color: rgb(7, 4, 4) !important; }[data-css=\"tve-u-15fa0bba5de\"] { float: none; margin-top: -27px !important; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-15fa0bba5df\"] { margin-top: -42px !important; }:not(#tve) [data-css=\"tve-u-15fa0bba5e0\"] { color: rgb(6, 1, 1) !important; }:not(#tve) [data-css=\"tve-u-15fa0bba5e1\"] { color: rgb(6, 1, 1) !important; }[data-css=\"tve-u-15fa0bba5e2\"] { margin-top: -14px !important; padding-bottom: 0px !important; padding-top: 5px !important; margin-bottom: 51px !important; }:not(#tve) [data-css=\"tve-u-15fa0bba5e3\"] { font-size: 25px !important; color: rgb(249, 8, 8) !important; }[data-css=\"tve-u-15fa0bba5e4\"] p { margin: 0px 0px 15px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-15fa0bba5e4\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-15fa0bba5e4\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-15fa0bba5e4\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-15fa0bba5e4\"] address { line-height: 1.45em; }[data-css=\"tve-u-15fa0bba5e6\"] { margin-top: -24px !important; }[data-css=\"tve-u-15fa0bba5e7\"] { padding-bottom: 0px !important; margin-top: -3px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-15fa0bba5e8\"] { font-size: 13px !important; color: rgb(6, 2, 2) !important; }[data-css=\"tve-u-15fa0bba5e9\"] { padding-bottom: 0px !important; margin-bottom: -1px !important; }[data-css=\"tve-u-15fa0bba5ea\"] { margin-left: 0px !important; padding-left: 10px !important; padding-bottom: 0px !important; padding-top: 0px !important; margin-bottom: -1px !important; }[data-css=\"tve-u-15fa0bba5eb\"] { max-width: 80.9%; }[data-css=\"tve-u-15fa0bba5ec\"] { max-width: 19.1%; }[data-css=\"tve-u-15fa0bba5ed\"] > .tcb-flex-col > .tcb-col { min-height: 1px; }[data-css=\"tve-u-15fa0bba5ed\"] { margin-left: 0px; min-height: inherit; }[data-css=\"tve-u-15fa0bba5ed\"] > .tcb-flex-col { padding-left: 0px; }:not(#tve) [data-css=\"tve-u-15fa0bba5ee\"] { font-size: 21px !important; color: rgb(15, 19, 190) !important; }[data-css=\"tve-u-15fa0bba5ef\"]::after { clear: both; }[data-css=\"tve-u-15fa0bba5f0\"] { float: left; width: 86px; z-index: 3; position: relative; margin-top: -7px !important; }[data-css=\"tve-u-15fa0bba5f1\"] { 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; }:not(#tve) [data-css=\"tve-u-15fa0bba5f4\"] { color: rgb(6, 1, 1) !important; }[data-css=\"tve-u-15fa7d19f54\"] { margin-top: 87px !important; }:not(#tve) [data-css=\"tve-u-15fa7d19f56\"] { color: rgb(7, 3, 3) !important; }[data-css=\"tve-u-15fa7d19f57\"] .tcb-button-link { background-image: none !important; background-color: rgb(242, 208, 24) !important; }[data-css=\"tve-u-15fa7d19f58\"] { margin-top: 8px !important; padding-left: 8px !important; }[data-css=\"tve-u-15fa7d19f59\"] { padding-left: 0px !important; margin-left: 5px !important; }:not(#tve) [data-css=\"tve-u-15fa7d19f59\"] p, :not(#tve) [data-css=\"tve-u-15fa7d19f59\"] li, :not(#tve) [data-css=\"tve-u-15fa7d19f59\"] blockquote, :not(#tve) [data-css=\"tve-u-15fa7d19f59\"] address { color: rgb(3, 1, 1); font-size: 14px; }[data-css=\"tve-u-15fa7d19f5a\"] { color: rgb(22, 150, 46); }[data-css=\"tve-u-15fa7d19f5c\"] { color: rgb(22, 150, 46); }[data-css=\"tve-u-15fa7d19f5d\"] { color: rgb(22, 150, 46); }:not(#tve) [data-css=\"tve-u-15fa7d19f5e\"] { font-size: 14px !important; color: rgb(7, 2, 2) !important; }[data-css=\"tve-u-15fa7d19f5e\"] { line-height: 1.4em !important; }[data-css=\"tve-u-15fa7d19f5f\"] { color: rgb(22, 150, 46); }[data-css=\"tve-u-15fa7d19f60\"] + div { clear: none; }[data-css=\"tve-u-15fa7d19f60\"] { float: none; margin-left: auto; margin-right: auto; width: 219px; margin-top: 0px !important; padding-top: 1px !important; }[data-css=\"tve-u-15fa7d19f61\"] { border: 3px solid rgb(9, 6, 245) !important; }:not(#tve) [data-css=\"tve-u-15fa7d19f62\"] { font-size: 23px !important; color: rgb(246, 14, 45) !important; }[data-css=\"tve-u-1691ae3fcac\"] .tcb-button-link { border-color: rgb(255, 228, 228); padding: 14px 22px; border-radius: 10px; overflow: hidden; background-image: none !important; background-color: rgb(244, 101, 7) !important; }:not(#tve) [data-css=\"tve-u-1691ae3fcac\"]:hover .tcb-button-link { background-color: rgb(218, 91, 5) !important; }:not(#tve) [data-css=\"tve-u-1691ae3fcac\"] .tcb-button-link { line-height: 1.2em; font-size: 24px; }[data-css=\"tve-u-1691ae3fcac\"] { margin-top: 0px !important; margin-bottom: 0px !important; }}@media (max-width: 1023px){:not(#tve) [data-css=\"tve-u-15fa7d19f56\"] { font-size: 12px !important; }[data-css=\"tve-u-15fa7d19f66\"] { max-width: 97px; }[data-css=\"tve-u-15fa7d19f68\"] { max-width: 95px; }[data-css=\"tve-u-15fa7d19f5f\"] { 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-15fa7d19f69\"] { max-width: 97px; margin-right: -9px !important; padding-right: 0px !important; }[data-css=\"tve-u-15fa7d19f5a\"] { 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-15fa7d19f6a\"] { max-width: 101px; margin-right: -16px !important; padding-right: 0px !important; padding-left: 14px !important; margin-left: -2px !important; }[data-css=\"tve-u-15fa7d19f5c\"] { font-size: 18px; width: 18px; height: 18px; margin-right: 56px !important; margin-left: -13px !important; padding-left: 0px !important; }[data-css=\"tve-u-15fa7d19f5d\"] { 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-15fa7d19f6b\"] { font-size: 13px !important; }:not(#tve) [data-css=\"tve-u-15fa7d19f62\"] { font-size: 13px !important; }[data-css=\"tve-u-15fa7d19f60\"] { 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-26740","page","type-page","status-publish","has-post-thumbnail","hentry","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/pages\/26740","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=26740"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/pages\/26740\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/47113"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=26740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}