{"id":1158,"date":"2018-01-17T10:34:52","date_gmt":"2018-01-17T10:34:52","guid":{"rendered":"http:\/\/www.deltapci.com\/?p=1158"},"modified":"2018-01-17T10:34:52","modified_gmt":"2018-01-17T10:34:52","slug":"aplicar-formato-condicional-a-una-fila","status":"publish","type":"post","link":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/2018\/01\/17\/aplicar-formato-condicional-a-una-fila\/","title":{"rendered":"C\u00f3mo aplicar formato condicional a una fila seg\u00fan el contenido de una celda"},"content":{"rendered":"

En este tutorial veremos c\u00f3mo aplicar formato condicional<\/a> a una fila si una celda de la misma cumple una condici\u00f3n especificada.<\/p>\n

Tenemos un listado de alumnos con las notas obtenidas en las diferentes materias, la nota media y la calificaci\u00f3n obtenida.<\/p>\n

Queremos resaltar la fila de aquellos alumnos que hayan obtenido una Matr\u00edcula<\/em> como nota final.<\/p>\n

\"Datos<\/p>\n

Para ello seleccionamos el rango de datos (A4:G10)<\/em> y pulsamos el bot\u00f3n Formato condicional<\/em><\/strong> (Ficha Inicio – Grupo Estilos),<\/em> escogiendo la opci\u00f3n Nueva regla\u2026<\/em><\/strong><\/p>\n

Dentro de las opciones que nos ofrece seleccionaremos Utilice una f\u00f3rmula que determine las celdas para aplicar formato<\/em><\/strong>.<\/p>\n

En el cuadro Dar formato a los valores donde esta f\u00f3rmula sea verdadera<\/em><\/strong> introducimos la condici\u00f3n que ha de cumplirse (que haya obtenido Matr\u00edcula<\/em> como nota final).<\/p>\n

=$G4 = \u201cMatr\u00edcula\u201d<\/strong><\/p>\n

F\u00edjate que dejamos la referencia a la celda como referencia mixta:<\/p>\n

\"Referencia<\/p>\n

Por \u00faltimo escogemos el formato que queremos aplicar; en este caso he escogido el texto en rojo oscuro y el fondo de la celda en rojo claro.<\/p>\n

\"F\u00f3rmula<\/p>\n

Aceptamos el cuadro de di\u00e1logo y ya aparecer\u00e1n resaltadas las filas de alumnos cuya nota final cumpla la condici\u00f3n especificada.<\/p>\n

\"Resultado<\/p>\n

(Si accedes al Administrador de reglas de formato condicionales – <\/em>a trav\u00e9s del bot\u00f3n Formato condicional <\/em>– nos indica a qu\u00e9 celda o rango de celdas debe aplicarse el formato. Como ya lo hab\u00edamos seleccionado al principio, ya nos indica el rango correcto <\/em>(A4:G10))<\/em>.<\/em><\/p>\n

\"Administrador<\/p>\n

Si quieres practicarlo, copia el ejemplo en una hoja de c\u00e1lculo y prueba a resaltar en amarillo claro los alumnos que hayan suspendido.<\/p>\n","protected":false},"excerpt":{"rendered":"

En este tutorial veremos c\u00f3mo aplicar formato condicional a una fila si una celda de la misma cumple una condici\u00f3n […]<\/p>\n","protected":false},"author":2,"featured_media":1159,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[8,9,10],"class_list":["post-1158","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriales","tag-excel","tag-formato-condicional","tag-ofimatica"],"_links":{"self":[{"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/posts\/1158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/comments?post=1158"}],"version-history":[{"count":0,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/posts\/1158\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/media?parent=1158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/categories?post=1158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/tags?post=1158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}