{"id":50770,"date":"2017-01-19T12:11:00","date_gmt":"2017-01-19T11:11:00","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=50770"},"modified":"2017-01-18T13:10:59","modified_gmt":"2017-01-18T12:10:59","slug":"gelijke-cellen-laten-oplichten","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/gelijke-cellen-laten-oplichten\/","title":{"rendered":"Gelijke cellen laten oplichten"},"content":{"rendered":"<p>V. Kan Excel gelijke cellen in twee verschillende kolommen laten oplichten? Ik bedoel: als de waarde in de tweede kolom gelijk is aan de waarde in de eerste kolom?<\/p>\n<p>A. Ja, dat kan met voorwaardelijke opmaak, maar er is een trucje.<\/p>\n<ul>\n<li>Selecteer de eerste cel van de tweede kolom (de eerste cel die moet oplichten)<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50774\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten-221x300.png\" alt=\"\" width=\"221\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten-221x300.png 221w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten.png 284w\" sizes=\"auto, (max-width: 221px) 100vw, 221px\" \/><\/a><\/li>\n<li>Start tab, <em>Voorwaardelijke opmaak, Nieuwe regel<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50771\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten1-300x169.png\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten1-300x169.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten1.png 650w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/em><\/li>\n<li><em>Cellen opmaken met, Celwaarde gelijk aan<\/em><\/li>\n<li>Tik =A2 (de truc is: g\u00e9\u00e9n &#8220;&#8221;, g\u00e9\u00e9n dollartekens)<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50772\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten2-300x197.png\" alt=\"\" width=\"300\" height=\"197\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten2-300x197.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten2.png 556w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>\u00c2\u00a0\u00c2\u00a0<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50773\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten3-300x121.png\" alt=\"\" width=\"300\" height=\"121\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten3-300x121.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-gelijkeoplichten3.png 744w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<li>Stel de opmaak in<\/li>\n<li>Kopieer de opmaak naar beneden<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan Excel gelijke cellen in twee verschillende kolommen laten oplichten? Ik bedoel: als de waarde in de tweede kolom gelijk is aan de waarde in de eerste kolom? A. Ja, dat kan met voorwaardelijke opmaak, maar er is een trucje. Selecteer de eerste cel van de tweede kolom (de<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":21,"footnotes":""},"categories":[464,54,375,79,10,246,391,160],"tags":[],"class_list":["post-50770","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-excel-office-2010","category-odisee","category-office","category-office-2010","category-office-2013","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 05:23:21","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=50770"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50770\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=50770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=50770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=50770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}