{"id":72,"date":"2016-01-25T07:00:00","date_gmt":"2016-01-25T12:00:00","guid":{"rendered":"https:\/\/serviciales.com\/?p=72"},"modified":"2025-03-05T10:52:35","modified_gmt":"2025-03-05T15:52:35","slug":"hojas-de-calculo-google-apps-formato-condicional","status":"publish","type":"post","link":"https:\/\/serviciales.com\/?p=72","title":{"rendered":"HOJAS DE CALCULO &#8211; GOOGLE APPS  &#8211; FORMATO CONDICIONAL"},"content":{"rendered":"<div>\n<h2><b>HOJAS DE CALCULO &#8211; GOOGLE APPS<\/b><\/h2>\n<h2><b>&#8211; FORMATO CONDICIONAL<\/b><\/h2>\n<div><\/div>\n<\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\">Permite cambiar el color de fuente y de fondo de una celda dependiendo su valor.<o:p><\/o:p><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\"><br \/><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\">Para ello haga lo siguiente:<o:p><\/o:p><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\"><br \/><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\"><br \/><\/span><\/div>\n<div style=\"mso-list: l0 level1 lfo1; text-indent: -18.0pt;\"><!--[if !supportLists]--><span style=\"font-family: &quot;segoe ui&quot; , sans-serif; font-size: 10.5pt; line-height: 115%;\">1.<span style=\"font-family: &quot;times new roman&quot;; font-size: 7pt; font-stretch: normal; line-height: normal;\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><!--[endif]--><span style=\"background: white; font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\">Seleccione los datos a los cuales desea aplicar un formato condicional, luego haga clic en el \u00edtem <b>\u201cFormato<\/b>=&gt; <b>Formato condicional\u201d<\/b>, le aparecer\u00e1 una&nbsp; ventana en donde podr\u00e1 definir criterios de celdas(mayor a, igual a\u2026), seleccione el formato que requiere( Color de texto y\/o color de fondo)<\/span><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><o:p><\/o:p><\/span><\/div>\n<div style=\"mso-list: l0 level1 lfo1; text-indent: -18.0pt;\"><!--[if !supportLists]--><span style=\"font-family: &quot;segoe ui&quot; , sans-serif; font-size: 10.5pt; line-height: 115%;\">2.<span style=\"font-family: &quot;times new roman&quot;; font-size: 7pt; font-stretch: normal; line-height: normal;\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><!--[endif]--><span style=\"background: white; font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\">Y haga clic en guardar regla.<\/span><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><o:p><\/o:p><\/span><\/div>\n<div><\/div>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/www.serviciales.com\/wp-content\/uploads\/2016\/01\/imagen1.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"164\" src=\"https:\/\/www.serviciales.com\/wp-content\/uploads\/2016\/01\/imagen1-300x154.png\" width=\"320\" \/><\/a><\/div>\n<div><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><br \/><\/span><\/div>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/www.serviciales.com\/wp-content\/uploads\/2016\/01\/imagen2-x.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"170\" src=\"https:\/\/www.serviciales.com\/wp-content\/uploads\/2016\/01\/imagen2-x-300x160.png\" width=\"320\" \/><\/a><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><br \/><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><!--[if gte vml 1]><v:shapetype coordsize=\"21600,21600\" o:spt=\"75\" o:preferrelative=\"t\"  path=\"m@4@5l@4@11@9@11@9@5xe\" filled=\"f\" stroked=\"f\"> <v:stroke joinstyle=\"miter\"\/> <v:formulas>  <v:f eqn=\"if lineDrawn pixelLineWidth 0\"\/>  <v:f eqn=\"sum @0 1 0\"\/>  <v:f eqn=\"sum 0 0 @1\"\/>  <v:f eqn=\"prod @2 1 2\"\/>  <v:f eqn=\"prod @3 21600 pixelWidth\"\/>  <v:f eqn=\"prod @3 21600 pixelHeight\"\/>  <v:f eqn=\"sum @0 0 1\"\/>  <v:f eqn=\"prod @6 1 2\"\/>  <v:f eqn=\"prod @7 21600 pixelWidth\"\/>  <v:f eqn=\"sum @8 21600 0\"\/>  <v:f eqn=\"prod @7 21600 pixelHeight\"\/>  <v:f eqn=\"sum @10 21600 0\"\/> <\/v:formulas> <v:path o:extrusionok=\"f\" gradientshapeok=\"t\" o:connecttype=\"rect\"\/> <o:lock v:ext=\"edit\" aspectratio=\"t\"\/><\/v:shapetype><v:shape id=\"Imagen_x0020_100\" o:sp type=\"#_x0000_t75\"  style='width:338.25pt;height:186.75pt;visibility:visible;mso-wrap-style:square'> <v:imagedata src=\"file:\/\/\/C:UserssistemasAppDataLocalTempmsohtmlclip1\u00001clip_image001.png\"   o:title=\"\" croptop=\"1961f\" cropbottom=\"19175f\" cropleft=\"7675f\" cropright=\"7764f\"\/><\/v:shape><![endif]--><!--[if !vml]--><!--[endif]--><o:p><\/o:p><\/span><\/div>\n<div><\/div>\n<div><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><!--[if gte vml 1]><v:shape id=\"Imagen_x0020_97\"  o:sp type=\"#_x0000_t75\" style='width:369pt;height:210pt;  visibility:visible;mso-wrap-style:square'> <v:imagedata src=\"file:\/\/\/C:UserssistemasAppDataLocalTempmsohtmlclip1\u00001clip_image003.png\"   o:title=\"\" croptop=\"1781f\" cropbottom=\"18699f\" cropleft=\"8008f\" cropright=\"7986f\"\/><\/v:shape><![endif]--><!--[if !vml]--><!--[endif]--><\/span><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><o:p><\/o:p><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><br \/><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\">Nota: Puede a\u00f1adir m\u00e1s condiciones haciendo clic en el enlace \u201ca\u00f1adir otra regla\u201d<o:p><\/o:p><\/span><\/div>\n<div style=\"mso-list: l1 level1 lfo1; mso-outline-level: 1; text-indent: -18.0pt;\"><\/div>\n<div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>HOJAS DE CALCULO &#8211; GOOGLE APPS &#8211; FORMATO CONDICIONAL Permite cambiar el color de fuente y de fondo de una celda dependiendo su valor. Para ello haga lo siguiente: 1.&nbsp;&nbsp;&nbsp;&nbsp; Seleccione los datos a los cuales desea aplicar un formato condicional, luego haga clic en el \u00edtem \u201cFormato=&gt; Formato condicional\u201d, le aparecer\u00e1 una&nbsp; ventana en [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":107,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-72","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sin-categoria"],"_links":{"self":[{"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/posts\/72","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/serviciales.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=72"}],"version-history":[{"count":1,"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/posts\/72\/revisions"}],"predecessor-version":[{"id":259,"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/posts\/72\/revisions\/259"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/serviciales.com\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"https:\/\/serviciales.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=72"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/serviciales.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=72"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/serviciales.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=72"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}