{"id":18829,"date":"2015-05-18T22:19:10","date_gmt":"2015-05-19T04:19:10","guid":{"rendered":"http:\/\/aplicaexcelcontable.com\/blog\/?p=18829"},"modified":"2025-02-12T13:17:37","modified_gmt":"2025-02-12T19:17:37","slug":"formato-condicional","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/formato-condicional.html","title":{"rendered":"Formato Condicional para Seleccionar Celdas en Blanco"},"content":{"rendered":"<h1 style=\"text-align: center;\">Formato condicional para seleccionar celdas en Blanco<\/h1>\n<p style=\"text-align: justify;\">Comencemos con el articulo Formato condicional en Excel para seleccionar celdas en Blanco.<\/p>\n<p style=\"text-align: justify;\">Hemos visto dos m\u00e9todos en el art\u00edculo anterior de como Seleccionar Celdas en Blancos. Ya viste los dos m\u00e9todos? Si no lo has visto te dejo los enlaces:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-seleccionar-filas-en-blanco-en-una-base-de-datos.html\" style=\"outline: none;\" target=\"_blank\"><span style=\"color: rgb(0, 23, 255);\"><strong>Haz clic aqu\u00ed para ver el M\u00e9todo 1<\/strong><\/span><\/a>.<\/p>\n<p style=\"text-align: center;\"><span style=\"color: rgb(0, 23, 255);\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-utilizar-filtros-en-excel-para-seleccionar-celdas-en-blanco.html\" style=\"outline: none;\" target=\"_blank\"><strong>Haz clic aqu\u00ed para ver el M\u00e9todo 2<\/strong><\/a><\/span>.<\/p>\n<p style=\"text-align: justify;\">Muy bien, tengo una pregunta para ti: Te gustar\u00eda conocer un m\u00e9todo m\u00e1s para seleccionar Celdas en Blanco en Excel?Hola Soy Roger Perez y hoy voy a compartir contigo el \u00faltimo m\u00e9todo de C\u00f3mo Aplicar Formato Condicional en Excel para seleccionar Celdas en Blanco.<\/p>\n<p style=\"text-align: justify;\">Comencemos:<\/p>\n<h2 style=\"text-align: center;\">Pasos para aplicar Formato condicional y seleccionar celdas en Blanco<\/h2>\n<p style=\"text-align: justify;\">Este m\u00e9todo es tan sencillo que seguramente te va a gustar mucho.<\/p>\n<p style=\"text-align: justify;\"><em><\/em>Para eso como siempre vamos a utilizar el mismo ejemplo de siempre.<\/p>\n<p style=\"text-align: justify;\">Para eso te pido que descargues el archivo, para que apliques todos los pasos de c\u00f3mo aplicar Formato Condicional:<\/p>\n<p><span style=\"width: 100%;\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" width=\"86\" height=\"86\" title=\"XLS\" src=\"\/\/farm3.staticflickr.com\/2818\/33290234771_090c549156_s.jpg\" style=\"aspect-ratio: auto 64 \/ 64;\" data-width=\"86\" data-height=\"86\" data-init-width=\"64\" data-init-height=\"64\" data-><\/span><\/p>\n<h1><a href=\"http:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/05\/Ejemplo-de-Como-Seleccionar-Filas-en-Blanco.xlsx\" style=\"outline: none;\" target=\"_blank\"><strong>Haz clic para Descargar el Archivo de Ejemplo<\/strong><\/a><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/10\/Calendario-en-Excel-a\u00f1o-2019.xlsx\"> <\/a><\/h1>\n<p><strong>Descargar el Libro y practica como aplica Formato Condicional en Excel para Seleccionar Celdas en Blanco.<\/strong><\/p>\n<p style=\"text-align: justify;\">Muy bien, considerando que ya has descargado el archivo vamos a seguir los siguientes pasos:<\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"color: rgb(255, 0, 0);\">NOTA:<\/span><\/strong> Antes de compartirte el M\u00e9todo 3, d\u00e9jame decirte que el M\u00e9todo 1 y 2 tienen una desventaja en cuanto al color que resaltamos.<\/p>\n<p style=\"text-align: justify;\">Si las celdas vac\u00edas se rellenan con valor entonces el color resaltado permanece, el cual tenemos que quitar el formato manualmente.<\/p>\n<p style=\"text-align: justify;\">He aqu\u00ed donde el formato condicional entra en acci\u00f3n, al rellenarse las celdas vac\u00edas con valor el color resaltado desaparece autom\u00e1ticamente.<\/p>\n<h3 style=\"text-align: center;\">Entonces comencemos:<\/h3>\n<ul>\n<li><span>Seleccionamos desde la B3:H1125 y nos ubicamos en la Pesta\u00f1a INICIO, Grupo Estilos y desplegamos la opci\u00f3n formato condicional:<\/span><\/li>\n<\/ul>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Formato Condicional\" width=\"419\" height=\"396\" title=\"Formato Condicional\" data-id=\"32301\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/01\/Formato-Condicional.png\" data-width=\"419\" data-height=\"396\" data-init-width=\"419\" data-init-height=\"396\" style=\"aspect-ratio: auto 419 \/ 396;\"><\/span><\/p>\n<ul>\n<li style=\"\"><span>Tal como se muestra en la imagen, seleccionamos el comando Nueva Regla, en seguida se muestra una ventana, dentro de este seleccionamos el tipo de regla \u201cAplicar Formato \u00danicamente a las Celdas que contengan\u201d.<\/span><\/li>\n<\/ul>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Formato Condicional\" width=\"624\" height=\"376\" title=\"Nueva regla de Formato\" data-id=\"32303\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/01\/Nueva-regla-de-Formato.png\" data-width=\"624\" data-height=\"376\" data-init-width=\"624\" data-init-height=\"376\" style=\"aspect-ratio: auto 624 \/ 376;\"><\/span><\/p>\n<h3 style=\"text-align: center;\">Continuamos:<\/h3>\n<ul>\n<li><span style=\"\">Muy bien, ahora nos ubicamos en la secci\u00f3n donde dice \u201cEditar una descripci\u00f3n de regla:\u201d desplegamos y seleccionamos Celdas en Blanco.<\/span><\/li>\n<\/ul>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Formato Condicional\" width=\"626\" height=\"375\" title=\"Nuevas reglas de Formato\" data-id=\"32305\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/01\/Nuevas-reglas-de-Formato.png\" data-width=\"626\" data-height=\"375\" data-init-width=\"626\" data-init-height=\"375\" style=\"aspect-ratio: auto 626 \/ 375;\"><\/span><\/p>\n<ul>\n<li><span style=\"\">Muy bien, ahora pulsamos clic en el bot\u00f3n formato, se presenta una venta, dentro de este nos ubicamos en la secci\u00f3n Relleno y seleccionamos el color amarillo, seguidamente pulsamos clic en aceptar.<\/span><\/li>\n<\/ul>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Formato Condicional\" width=\"622\" height=\"626\" title=\"Formato de Celdas\" data-id=\"32308\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/01\/Formato-de-Celdas.png\" data-width=\"622\" data-height=\"626\" data-init-width=\"622\" data-init-height=\"626\" style=\"aspect-ratio: auto 622 \/ 626;\"><\/span><\/p>\n<ul>\n<li><span style=\"\">Puedes notar que la Vista previa ahora esta en amarrillo, ahora solo pulsamos clic en aceptar y Listo.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Todas las Celdas en Blanco ahora est\u00e1n resaltados en amarrillo gracias a la regla aplicada del formato condicional.<\/p>\n<p style=\"text-align: justify;\">Te invito a que hagas una prueba, introduce un valor en las Celdas resaltadas en amarrillo y veras como autom\u00e1ticamente se desvanece el color amarrillo.<\/p>\n<p style=\"text-align: justify;\">Esto debido a que la celda ya tiene un valor y las celdas que no tienen valor siempre ser\u00e1 resaltado en amarrillo.<\/p>\n<p style=\"\">Que tal te pareci\u00f3 el articulo de hoy \u00abFormato condicional para seleccionar celdas en Blanco\u00bb? Te gusto?<\/p>\n<p style=\"\">Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Facebook<\/a>, a continuaci\u00f3n, te dejo un bot\u00f3n para que puedas compartirlo:<\/p>\n<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">&nbsp;<\/span><a href=\"#comentario\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Formato condicional para seleccionar celdas en Blanco Comencemos con el articulo Formato condicional en Excel para seleccionar celdas en Blanco. Hemos visto dos m\u00e9todos en el art\u00edculo anterior de como Seleccionar Celdas en Blancos. Ya viste los dos m\u00e9todos? Si no lo has visto te dejo los enlaces: Haz clic aqu\u00ed para ver el M\u00e9todo [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":32301,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\"><h1 data-css=\"tve-u-1612a541446\" style=\"text-align: center;\" class=\"\">Formato condicional para seleccionar celdas en Blanco<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1612a55aae0\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1612a55aae3\" style=\"text-align: justify;\">Comencemos con el articulo Formato condicional en Excel para seleccionar celdas en Blanco.<\/p><p data-css=\"tve-u-1612a55aae3\" style=\"text-align: justify;\">Hemos visto dos m\u00e9todos en el art\u00edculo anterior de como Seleccionar Celdas en Blancos. Ya viste los dos m\u00e9todos? Si no lo has visto te dejo los enlaces:<\/p><p data-css=\"tve-u-1612a55aae3\" style=\"text-align: center;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-seleccionar-filas-en-blanco-en-una-base-de-datos.html\" class=\"\" style=\"outline: none;\" target=\"_blank\"><span data-css=\"tve-u-1612a5daabe\" style=\"color: rgb(0, 23, 255);\"><strong>Haz clic aqu\u00ed para ver el M\u00e9todo 1<\/strong><\/span><\/a>.<\/p><p data-css=\"tve-u-1612a55aae3\" style=\"text-align: center;\"><span data-css=\"tve-u-1612a5ea201\" style=\"color: rgb(0, 23, 255);\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-utilizar-filtros-en-excel-para-seleccionar-celdas-en-blanco.html\" class=\"\" style=\"outline: none;\" target=\"_blank\"><strong>Haz clic aqu\u00ed para ver el M\u00e9todo 2<\/strong><\/a><\/span>.<\/p><p data-css=\"tve-u-1612a55aae3\" style=\"text-align: justify;\">Muy bien, tengo una pregunta para ti: Te gustar\u00eda conocer un m\u00e9todo m\u00e1s para seleccionar Celdas en Blanco en Excel?<br><br>Hola Soy Roger Perez y hoy voy a compartir contigo el \u00faltimo m\u00e9todo de C\u00f3mo Aplicar Formato Condicional en Excel para seleccionar Celdas en Blanco.<\/p><p data-css=\"tve-u-1612a55aae3\" style=\"text-align: justify;\">Comencemos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\" data-css=\"tve-u-1612a64a676\"><h2 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-194fb950756\">Pasos para aplicar Formato condicional y seleccionar celdas en Blanco<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-1612a64ce0c\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1612a640752\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1612a640755\" style=\"text-align: justify;\">Este m\u00e9todo es tan sencillo que seguramente te va a gustar mucho.<\/p><p data-css=\"tve-u-1612a640755\" style=\"text-align: justify;\"><em><\/em>Para eso como siempre vamos a utilizar el mismo ejemplo de siempre.<\/p><p data-css=\"tve-u-1612a640755\" style=\"text-align: justify;\">Para eso te pido que descargues el archivo, para que apliques todos los pasos de c\u00f3mo aplicar Formato Condicional:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-1612a6524fc\"><div class=\"tve-content-box-background\" data-css=\"tve-u-1612a652505\" 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: 674.938;\"><div class=\"tcb-flex-row tcb-resized tcb--cols--2\" data-css=\"tve-u-1612a652500\"><div class=\"tcb-flex-col\" data-css=\"tve-u-1612a6524ff\" style=\"\"><div class=\"tcb-col\"><div class=\"tcb-clear\" data-css=\"tve-u-1612a652503\"><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1612a652504\" data-clear=\"both\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image\" alt=\"\" width=\"86\" height=\"86\" title=\"XLS\" src=\"\/\/farm3.staticflickr.com\/2818\/33290234771_090c549156_s.jpg\" style=\"aspect-ratio: auto 64 \/ 64;\" data-width=\"86\" data-height=\"86\" data-init-width=\"64\" data-init-height=\"64\"><\/span><\/div><\/div><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-1612a6524fe\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-1612a6524fb\"><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-1612a6524f8\" data-tag=\"h1\"><h1 data-css=\"tve-u-1612a652501\" class=\"\"><a href=\"http:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/05\/Ejemplo-de-Como-Seleccionar-Filas-en-Blanco.xlsx\" class=\"\" style=\"outline: none;\" target=\"_blank\"><strong>Haz clic para Descargar el Archivo de Ejemplo<\/strong><\/a><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/10\/Calendario-en-Excel-a\u00f1o-2019.xlsx\"> <\/a><\/h1><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" data-css=\"tve-u-1612a6524f5\"><p data-css=\"tve-u-1612a6524fa\"><strong>Descargar el Libro y practica como aplica Formato Condicional en Excel para Seleccionar Celdas en Blanco.<\/strong><\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-1612a6c6ec5\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1612a6ba7ae\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1612a6ba7b0\" style=\"text-align: justify;\">Muy bien, considerando que ya has descargado el archivo vamos a seguir los siguientes pasos:<\/p><p data-css=\"tve-u-1612a6ba7b0\" style=\"text-align: justify;\"><strong><span style=\"color: rgb(255, 0, 0);\" data-css=\"tve-u-1612a6c0402\">NOTA:<\/span><\/strong> Antes de compartirte el M\u00e9todo 3, d\u00e9jame decirte que el M\u00e9todo 1 y 2 tienen una desventaja en cuanto al color que resaltamos.<\/p><p data-css=\"tve-u-1612a6ba7b0\" style=\"text-align: justify;\">Si las celdas vac\u00edas se rellenan con valor entonces el color resaltado permanece, el cual tenemos que quitar el formato manualmente.<\/p><p data-css=\"tve-u-1612a6ba7b0\" style=\"text-align: justify;\">He aqu\u00ed donde el formato condicional entra en acci\u00f3n, al rellenarse las celdas vac\u00edas con valor el color resaltado desaparece autom\u00e1ticamente.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\" data-css=\"tve-u-1612a772fec\"><h3 class=\"\" style=\"text-align: center;\">Entonces comencemos:<\/h3><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(0, 0, 0)\" data-css=\"tve-u-1612a6d8d03\"><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-icon-inherit-style\" data-css=\"tve-u-1612a6d76c0\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<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>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\">Seleccionamos desde la B3:H1125 y nos ubicamos en la Pesta\u00f1a INICIO, Grupo Estilos y desplegamos la opci\u00f3n formato condicional:<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1612a733583\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image wp-image-32301 tcb-moved-image\" alt=\"Formato Condicional\" width=\"419\" height=\"396\" title=\"Formato Condicional\" data-id=\"32301\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/01\/Formato-Condicional.png\" data-width=\"419\" data-height=\"396\" data-init-width=\"419\" data-init-height=\"396\" style=\"aspect-ratio: auto 419 \/ 396;\" data-css=\"tve-u-194fb961362\"><\/span><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(0, 0, 0)\" data-css=\"tve-u-1612a79c583\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" style=\"\"><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-1612a79abac\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<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>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-194fb961bb5\">Tal como se muestra en la imagen, seleccionamos el comando Nueva Regla, en seguida se muestra una ventana, dentro de este seleccionamos el tipo de regla \u201cAplicar Formato \u00danicamente a las Celdas que contengan\u201d.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1612a7f8876\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image wp-image-32303 tcb-moved-image\" alt=\"Formato Condicional\" width=\"624\" height=\"376\" title=\"Nueva regla de Formato\" data-id=\"32303\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/01\/Nueva-regla-de-Formato.png\" data-width=\"624\" data-height=\"376\" data-init-width=\"624\" data-init-height=\"376\" style=\"aspect-ratio: auto 624 \/ 376;\" data-css=\"tve-u-194fb964285\"><\/span><\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\" data-css=\"tve-u-1612a8b6368\"><h3 class=\"\" style=\"text-align: center;\">Continuamos:<\/h3><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(0, 0, 0)\" data-css=\"tve-u-1612a85e488\"><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-icon-inherit-style\" data-css=\"tve-u-1612a85d17e\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<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>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-194fb964b85\" style=\"\">Muy bien, ahora nos ubicamos en la secci\u00f3n donde dice \u201cEditar una descripci\u00f3n de regla:\u201d desplegamos y seleccionamos Celdas en Blanco.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1612a88b089\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image wp-image-32305\" alt=\"Formato Condicional\" width=\"626\" height=\"375\" title=\"Nuevas reglas de Formato\" data-id=\"32305\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/01\/Nuevas-reglas-de-Formato.png\" data-width=\"626\" data-height=\"375\" data-init-width=\"626\" data-init-height=\"375\" style=\"aspect-ratio: auto 626 \/ 375;\"><\/span><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(0, 0, 0)\" data-css=\"tve-u-1612a8f63e5\"><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-icon-inherit-style\" data-css=\"tve-u-1612a8f48a3\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<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>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-194fb968400\" style=\"\">Muy bien, ahora pulsamos clic en el bot\u00f3n formato, se presenta una venta, dentro de este nos ubicamos en la secci\u00f3n Relleno y seleccionamos el color amarillo, seguidamente pulsamos clic en aceptar.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1612a94d32c\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image wp-image-32308\" alt=\"Formato Condicional\" width=\"622\" height=\"626\" title=\"Formato de Celdas\" data-id=\"32308\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/01\/Formato-de-Celdas.png\" data-width=\"622\" data-height=\"626\" data-init-width=\"622\" data-init-height=\"626\" style=\"aspect-ratio: auto 622 \/ 626;\"><\/span><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(0, 0, 0)\" data-css=\"tve-u-1612a95df51\"><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-icon-inherit-style\" data-css=\"tve-u-1612a95c40f\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<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>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-194fb96aa10\" style=\"\">Puedes notar que la Vista previa ahora esta en amarrillo, ahora solo pulsamos clic en aceptar y Listo.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-1612a98841c\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1612a982705\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1612a982707\" style=\"text-align: justify;\">Todas las Celdas en Blanco ahora est\u00e1n resaltados en amarrillo gracias a la regla aplicada del formato condicional.<\/p><p data-css=\"tve-u-1612a982707\" style=\"text-align: justify;\">Te invito a que hagas una prueba, introduce un valor en las Celdas resaltadas en amarrillo y veras como autom\u00e1ticamente se desvanece el color amarrillo.<\/p><p data-css=\"tve-u-1612a982707\" style=\"text-align: justify;\">Esto debido a que la celda ya tiene un valor y las celdas que no tienen valor siempre ser\u00e1 resaltado en amarrillo.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-194fb9738d3\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194fb9738d2\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Que tal te pareci\u00f3 el articulo de hoy \"Formato condicional para seleccionar celdas en Blanco\"? Te gusto?<\/p><p style=\"\">Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\">Facebook<\/a>, a continuaci\u00f3n, te dejo un bot\u00f3n para que puedas compartirlo:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-1612a9986c1\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb\">\n<div class=\"tve_s_item tve_s_fb_share\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/formato-condicional-en-excel-para-seleccionar-celdas-en-blanco.html\" data-label=\"Compartir\">\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\">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-194fb97c41d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194fb97c41c\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-194fb97c41e\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-194fb97c41f\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-194fb97c420\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-194fb97c421\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-194fb97c422\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/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-1612a9986c1\"] { float: none; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-1612a98841c\"] { margin-top: -15px !important; }:not(#tve) [data-css=\"tve-u-1612a95df51\"] p, :not(#tve) [data-css=\"tve-u-1612a95df51\"] li, :not(#tve) [data-css=\"tve-u-1612a95df51\"] blockquote, :not(#tve) [data-css=\"tve-u-1612a95df51\"] address, :not(#tve) [data-css=\"tve-u-1612a95df51\"] h1, :not(#tve) [data-css=\"tve-u-1612a95df51\"] h2, :not(#tve) [data-css=\"tve-u-1612a95df51\"] h3, :not(#tve) [data-css=\"tve-u-1612a95df51\"] h4, :not(#tve) [data-css=\"tve-u-1612a95df51\"] h5, :not(#tve) [data-css=\"tve-u-1612a95df51\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612a95c40f\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612a94d32c\"] + div { clear: none; }[data-css=\"tve-u-1612a94d32c\"] { float: none; width: 622px; margin-left: auto !important; margin-right: auto !important; margin-top: -15px !important; }:not(#tve) [data-css=\"tve-u-1612a8f63e5\"] p, :not(#tve) [data-css=\"tve-u-1612a8f63e5\"] li, :not(#tve) [data-css=\"tve-u-1612a8f63e5\"] blockquote, :not(#tve) [data-css=\"tve-u-1612a8f63e5\"] address, :not(#tve) [data-css=\"tve-u-1612a8f63e5\"] h1, :not(#tve) [data-css=\"tve-u-1612a8f63e5\"] h2, :not(#tve) [data-css=\"tve-u-1612a8f63e5\"] h3, :not(#tve) [data-css=\"tve-u-1612a8f63e5\"] h4, :not(#tve) [data-css=\"tve-u-1612a8f63e5\"] h5, :not(#tve) [data-css=\"tve-u-1612a8f63e5\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612a8f48a3\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612a8b6368\"] { margin-top: 50px !important; }[data-css=\"tve-u-1612a88b089\"] + div { clear: none; }[data-css=\"tve-u-1612a88b089\"] { float: none; width: 626px; margin-left: auto !important; margin-right: auto !important; margin-top: -15px !important; }[data-css=\"tve-u-1612a85e488\"] { margin-top: -1px !important; }:not(#tve) [data-css=\"tve-u-1612a85e488\"] p, :not(#tve) [data-css=\"tve-u-1612a85e488\"] li, :not(#tve) [data-css=\"tve-u-1612a85e488\"] blockquote, :not(#tve) [data-css=\"tve-u-1612a85e488\"] address, :not(#tve) [data-css=\"tve-u-1612a85e488\"] h1, :not(#tve) [data-css=\"tve-u-1612a85e488\"] h2, :not(#tve) [data-css=\"tve-u-1612a85e488\"] h3, :not(#tve) [data-css=\"tve-u-1612a85e488\"] h4, :not(#tve) [data-css=\"tve-u-1612a85e488\"] h5, :not(#tve) [data-css=\"tve-u-1612a85e488\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612a85d17e\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612a7f8876\"] + div { clear: none; }[data-css=\"tve-u-1612a7f8876\"] { float: none; width: 624px; margin-left: auto !important; margin-right: auto !important; margin-top: -10px !important; }[data-css=\"tve-u-1612a79c583\"] { margin-top: 40px !important; --tve-font-size: 20px; }:not(#tve) [data-css=\"tve-u-1612a79c583\"] p, :not(#tve) [data-css=\"tve-u-1612a79c583\"] li, :not(#tve) [data-css=\"tve-u-1612a79c583\"] blockquote, :not(#tve) [data-css=\"tve-u-1612a79c583\"] address, :not(#tve) [data-css=\"tve-u-1612a79c583\"] h1, :not(#tve) [data-css=\"tve-u-1612a79c583\"] h2, :not(#tve) [data-css=\"tve-u-1612a79c583\"] h3, :not(#tve) [data-css=\"tve-u-1612a79c583\"] h4, :not(#tve) [data-css=\"tve-u-1612a79c583\"] h5, :not(#tve) [data-css=\"tve-u-1612a79c583\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612a79abac\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612a6d8d03\"] { margin-top: -1px !important; }[data-css=\"tve-u-1612a772fec\"] { margin-top: 35px !important; }[data-css=\"tve-u-1612a733583\"] + div { clear: none; }[data-css=\"tve-u-1612a733583\"] { float: none; width: 419px; margin-left: auto !important; margin-right: auto !important; margin-top: -10px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-1612a6d8d03\"] p, :not(#tve) [data-css=\"tve-u-1612a6d8d03\"] li, :not(#tve) [data-css=\"tve-u-1612a6d8d03\"] blockquote, :not(#tve) [data-css=\"tve-u-1612a6d8d03\"] address, :not(#tve) [data-css=\"tve-u-1612a6d8d03\"] h1, :not(#tve) [data-css=\"tve-u-1612a6d8d03\"] h2, :not(#tve) [data-css=\"tve-u-1612a6d8d03\"] h3, :not(#tve) [data-css=\"tve-u-1612a6d8d03\"] h4, :not(#tve) [data-css=\"tve-u-1612a6d8d03\"] h5, :not(#tve) [data-css=\"tve-u-1612a6d8d03\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612a6d76c0\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612a6c6ec5\"] { margin-top: 31px !important; }[data-css=\"tve-u-1612a6c0402\"] { color: rgb(255, 0, 0) !important; }[data-css=\"tve-u-1612a64ce0c\"] { margin-top: 11px !important; padding-top: 0px !important; }[data-css=\"tve-u-1612a64a676\"] { margin-top: 35px !important; }[data-css=\"tve-u-1612a5ea201\"] { color: rgb(0, 23, 255) !important; }[data-css=\"tve-u-1612a5daabe\"] { color: rgb(0, 23, 255) !important; }:not(#tve) [data-css=\"tve-u-1612a541446\"] { color: rgb(255, 0, 0) !important; font-size: 42px !important; }[data-css=\"tve-u-1612a55aae0\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1612a55aae3\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1612a640752\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1612a640755\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1612a6524f5\"] { margin-top: -24px !important; padding-left: 3px !important; margin-left: -8px !important; }[data-css=\"tve-u-1612a6524f8\"] { padding-bottom: 0px !important; margin-top: -3px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-1612a6524fa\"] { font-size: 13px !important; color: rgb(6, 2, 2) !important; }[data-css=\"tve-u-1612a6524fb\"] { padding-bottom: 0px !important; margin-bottom: -1px !important; }[data-css=\"tve-u-1612a6524fc\"] { margin-left: 0px !important; padding-left: 10px !important; padding-bottom: 0px !important; padding-top: 0px !important; margin-bottom: -1px !important; }[data-css=\"tve-u-1612a6524fe\"] { max-width: 80.9%; }[data-css=\"tve-u-1612a6524ff\"] { max-width: 19.1%; }[data-css=\"tve-u-1612a652500\"] > .tcb-flex-col > .tcb-col { min-height: 1px; }[data-css=\"tve-u-1612a652500\"] { margin-left: 0px; min-height: inherit; }[data-css=\"tve-u-1612a652500\"] > .tcb-flex-col { padding-left: 0px; }:not(#tve) [data-css=\"tve-u-1612a652501\"] { font-size: 21px !important; color: rgb(0, 23, 255) !important; }[data-css=\"tve-u-1612a652503\"]::after { clear: both; }[data-css=\"tve-u-1612a652504\"] { float: left; width: 86px; z-index: 3; position: relative; margin-top: -7px !important; }[data-css=\"tve-u-1612a652505\"] { clip-path: url(\"#clip-top-b88a515ccdde\"); -webkit-clip-path: url(\"#clip-top-b88a515ccdde\");  border: 5px solid rgb(17, 133, 47) !important; }[data-css=\"tve-u-1612a6ba7ae\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1612a6ba7b0\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1612a982705\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1612a982707\"] { color: rgb(10, 0, 0) !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1612a55aae0\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a55aae0\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a55aae0\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a55aae0\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a55aae0\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a55aae0\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-1612a55aae0\"] { --tve-font-size: 20px; }:not(#tve) [data-css=\"tve-u-194fb950756\"] { text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1612a640752\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a640752\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a640752\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a640752\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a640752\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a640752\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-1612a640752\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1612a6ba7ae\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a6ba7ae\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a6ba7ae\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a6ba7ae\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a6ba7ae\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a6ba7ae\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-1612a6ba7ae\"] { --tve-font-size: 20px; }:not(#tve) [data-css=\"tve-u-1612a79c583\"] li { font-size: var(--tve-font-size, 20px) !important; }:not(#tve) [data-css=\"tve-u-194fb964b85\"] { font-size: 20px !important; }:not(#tve) [data-css=\"tve-u-194fb968400\"] { font-size: 20px !important; }:not(#tve) [data-css=\"tve-u-194fb96aa10\"] { font-size: 20px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1612a982705\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a982705\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a982705\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a982705\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a982705\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612a982705\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-1612a982705\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-194fb9738d2\"] { --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-194fb9738d2\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb9738d2\"] 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-194fb9738d2\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-194fb9738d3\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-194fb97c41c\"] { --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-194fb97c41c\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-194fb97c41c\"] 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-194fb97c41c\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-194fb97c41d\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-194fb97c41e\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-194fb97c41f\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-194fb97c420\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-194fb97c421\"] { --tcb-text-highlight-color: rgb(30, 184, 76) !important; }[data-css=\"tve-u-194fb97c422\"] { --tcb-text-highlight-color: transparent !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":[1],"tags":[234,233,66,86],"class_list":["post-18829","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-y-contabilidad","tag-celdas","tag-celdas-en-blanco","tag-excel","tag-formato-condicional","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/18829","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=18829"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/18829\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/32301"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=18829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=18829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=18829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}