{"id":215284,"date":"2022-08-12T13:52:00","date_gmt":"2022-08-12T10:52:00","guid":{"rendered":"https:\/\/goodroid.mediadoma.com\/?p=215284"},"modified":"2022-11-09T04:00:39","modified_gmt":"2022-11-09T01:00:39","slug":"ueksikasjalik-juhend-tingimusvormingu-rakendamiseks-googlei-arvutustabelites","status":"publish","type":"post","link":"https:\/\/goodroid.mediadoma.com\/et\/ueksikasjalik-juhend-tingimusvormingu-rakendamiseks-googlei-arvutustabelites\/","title":{"rendered":"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#8217;i arvutustabelites"},"content":{"rendered":"\n<p>Tingimuslik vormindamine on iga arvutustabeli oluline funktsioon. Selle peamine eelis on see, et see v\u00f5imaldab kasutajal t\u00f6\u00f6lehe lahtrit v\u00f5i lahtrite vahemikku visuaalselt esile t\u00f5sta, m\u00e4\u00e4rates neile konkreetse vormingu. K\u00f5nealused lahtrid v\u00f5i selle sisu vormindatakse automaatselt m\u00e4\u00e4ratletud vormingusse olenevalt m\u00f5nest tingimusest ja sellest tulenevalt ka nimest tingimuslik vorming.<\/p>\n<p>Selles artiklis n\u00e4itan samm-sammult, kuidas saate rakendada mitmele lahtrile tingimusvormingut. N\u00e4itena v\u00f5tan v\u00e4ikese komplekti h\u00fcpoteetilisi andmeid ja rakendan nende lahtrite taustav\u00e4rvile tingimusliku vormingu vastavalt neis sisalduvate temperatuuriandmete v\u00e4\u00e4rtusele.<\/p>\n<p>Kasutame sinist t\u00e4histamaks k\u00fclma temperatuuri alla 10 kraadi, rohelist t\u00e4histamaks meeldivat temperatuuri 11\u201325 kraadi ja punast, et t\u00e4histada \u00fcle 25 kraadist kuuma. Alustame:<\/p>\n<h2><strong>Tingimusvormingu kasutamine Google'i arvutustabelites<\/strong><\/h2>\n<p><strong>1 samm:<\/strong> k\u00fclastage <a href=\"https:\/\/docs.google.com\/spreadsheets\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">Google'i arvutustabeleid<\/a> ja alustage t\u00fchja lehe loomist.<\/p>\n<p><strong>2 samm:<\/strong> valmistage kaks veergu <strong>&quot;P\u00e4evad&quot;<\/strong> ja <strong>&quot;Temperatuur&quot;<\/strong> vastavalt D ja E, nagu on n\u00e4idatud viitejoonisel.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0a62aff6.png\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0a62aff6.png\" alt=\"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>3 samm:<\/strong> Oletame, et temperatuur alla 10C on meie skaalal k\u00f5ige k\u00fclmem ja me tahame v\u00e4rvida raku tausta tumesiniseks, kui temperatuur on alla 10C.<\/p>\n<p><strong>4 samm:<\/strong> eelmise etapi puhul lisame lahtrisse E10 reegli. Kl\u00f5psake men\u00fc\u00fcl <strong>&quot;Vorming&quot;<\/strong> ja seej\u00e4rel <strong>&quot;Tingimuslik vormindamine&quot;<\/strong>. Ekraani paremale k\u00fcljele ilmub v\u00e4ike aken <strong>&quot;Tingimuslik vormindamine&quot; .<\/strong><\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0a9b9927.png\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0a9b9927.png\" alt=\"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>5 samm:<\/strong> kl\u00f5psake selles aknas jaotises <strong>\u201eVormingureeglid &quot; kasti<\/strong> <strong>\u201ePole t\u00fchi&#8221;<\/strong>, et saada rippmen\u00fc\u00fc. Kerige alla ja leidke valik <strong>&quot;V\u00e4hem kui&quot;<\/strong> ja valige see, kl\u00f5psates sellel.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0acab059.jpg\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0acab059.jpg\" alt=\"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>6 toiming:<\/strong> sisestage v\u00e4ljale \u201e <strong>V\u00e4\u00e4rtus v\u00f5i valem&#8221;<\/strong> v\u00e4\u00e4rtus 10.<\/p>\n<p><strong>7 samm:<\/strong> jaotises <strong>\u201eVormingu stiil&#8221;<\/strong> kl\u00f5psake pooleldi t\u00e4idetud \u00e4mbri ikooniga nuppu. Ilmub v\u00e4rvivalikute aken. Selles aknas valige tumesinine v\u00e4rv.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0b08c5ae.jpg\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0b08c5ae.jpg\" alt=\"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>8 samm:<\/strong> meeldiva temperatuuri lisamiseks kl\u00f5psake akna allosas nuppu <strong>\u201e+ Lisa veel \u00fcks reegel&#8221; .<\/strong><\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0b3a10a6.jpg\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0b3a10a6.jpg\" alt=\"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>9 samm:<\/strong> seekord valige jaotises <strong>&quot;Vormingureeglid<\/strong> <strong>&quot; valik &quot;On vahemikus&quot;<\/strong> ja tippige t\u00fchjadesse kastidesse vastavalt 10 ja 25.<\/p>\n<p><strong>10 samm:<\/strong> valige jaotises <strong>\u201eVormindamisstiil&#8221;<\/strong> roheline v\u00e4rv. Seej\u00e4rel kl\u00f5psake viimase reegli lisamiseks nuppu <strong>\u201e+ Lisa veel \u00fcks reegel&#8221; .<\/strong><\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0b75c890.jpg\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0b75c890.jpg\" alt=\"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>11 samm: jaotise<\/strong> <strong>\u201eVormingureeglid&#8221;<\/strong> viimase juhtumi puhul valige suvand <strong>\u201eSuurem kui&#8221;<\/strong> ja tippige selle j\u00e4rel olevasse t\u00fchja kasti 25.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0ba7ae1b.jpg\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0ba7ae1b.jpg\" alt=\"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>12 samm:<\/strong> valige jaotises <strong>&quot;Vormindamisstiil&quot;<\/strong> punane v\u00e4rv ja seej\u00e4rel kl\u00f5psake rohelist nuppu <strong>&quot;Valmis&quot;<\/strong>. Kolm reeglit on lisatud. J\u00e4rgmisena tuleb laiendada vormingut mitmele lahtrile ja seej\u00e4rel lisada m\u00f5ned n\u00e4idisandmed, et n\u00e4ha k\u00e4itumist.<\/p>\n<p><strong>13 samm:<\/strong> suunake kursor v\u00e4ikesele sinisele ruudule lahtri E10 esilet\u00f5stjas. Kursor muutub suuremaks plussikooniks.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0bdc38ca.jpg\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0bdc38ca.jpg\" alt=\"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>14 samm:<\/strong> vajutage hiire vasakut nuppu ja hoidke seda all, kerige alla, et kopeerida ja kleepida lahtri E10 vorming selle all olevatesse lahtritesse.<\/p>\n<p><strong>15 samm:<\/strong> sisestage lahtritesse E10, E11 ja E12 vastavalt 3, 12 ja 30. M\u00e4rkate, et nende lahtrite taust on automaatselt muutunud nende konfigureeritud vormingureeglitega.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0c17e6b6.jpg\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0c17e6b6.jpg\" alt=\"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>16 samm:<\/strong> viimase sammuna sisestage \u00fclej\u00e4\u00e4nud lahtritesse oma valitud andmed ja m\u00e4rkige \u00fcles nende k\u00e4itumine.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0c4e6af2.png\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205484-62f0a0c4e6af2.png\" alt=\"\u00dcksikasjalik juhend tingimusvormingu rakendamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<h2><strong>Pakkimine<\/strong><\/h2>\n<p>See artikkel n\u00e4itas samm-sammult tingimusvormingu kasutamist Google'i arvutustabelites v\u00e4ikese hulga h\u00fcpoteetiliste temperatuuriandmete jaoks.<\/p>\n<p>Kasutage meie n\u00e4ite abil Google'i arvutustabelite tingimusvormingu valikut v\u00f5i kasutage enda oma ja andke mulle kommentaaride jaotises tulemustest teada.<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/www.gtricks.com\" class=\"external external_icon\">www.gtricks.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tingimuslik vormindamine on iga arvutustabeli oluline funktsioon. Selle peamine eelis on see, et see v\u00f5imaldab kasutajal lahtrit v\u00f5i vahemikku visuaalselt eristada<\/p>\n","protected":false},"author":1,"featured_media":205485,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[777,676,636,825],"tags":[],"class_list":["post-215284","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-arvustus","category-google-docs-3","category-kindral","category-opikud"],"_links":{"self":[{"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/215284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/comments?post=215284"}],"version-history":[{"count":0,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/215284\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/media\/205485"}],"wp:attachment":[{"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/media?parent=215284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/categories?post=215284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/tags?post=215284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}