{"id":2597,"date":"2017-06-22T15:40:37","date_gmt":"2017-06-22T14:40:37","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=2597"},"modified":"2017-06-19T16:09:10","modified_gmt":"2017-06-19T15:09:10","slug":"voorwaardelijk-opmaak-van-strings","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/voorwaardelijk-opmaak-van-strings\/","title":{"rendered":"Voorwaardelijk opmaak van strings"},"content":{"rendered":"<p>V. Kan ik teksten opmaken in Excel? Met voorwaardelijke opmaak, zoals getallen.<\/p>\n<p>A. Ja, dat kan.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51484\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/xl-conformat-text1-1-291x300.png\" alt=\"\" width=\"291\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/xl-conformat-text1-1-291x300.png 291w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/xl-conformat-text1-1.png 546w\" sizes=\"auto, (max-width: 291px) 100vw, 291px\" \/><\/p>\n<ul>\n<li>Een aantal dingen liggen voor de hand\n<ul>\n<li>dubbele waarden laten markeren<\/li>\n<li>teksten\/cellen laten\u00c2\u00a0 markeren die een bepaalde tekst bevat<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51485\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/xl-conformat-text2-300x116.png\" alt=\"\" width=\"300\" height=\"116\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/xl-conformat-text2-300x116.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/xl-conformat-text2.png 629w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<\/ul>\n<\/li>\n<li>Andere dingen kunnen ook\n<ul>\n<li>groter dan \/ kleiner dan \/ tussen &#8211; houd er rekening mee dat Excel de teksten intern sorteert, en op basis daarvan kan het programma bepalen of iets eerder of verderop komt in de sortering<\/li>\n<\/ul>\n<\/li>\n<li>Wat niet kan is de hoogste x % markeren<\/li>\n<\/ul>\n<p>Eens het criterium ingesteld, kan de opmaak van de markering kiezen. De mogelijkheden voor lettertype zijn beperkt (tekenstijl, onderstrepen, doorhalen, kleur en omranding)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51486\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/xl-conformat-text3-300x277.png\" alt=\"\" width=\"300\" height=\"277\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/xl-conformat-text3-300x277.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/xl-conformat-text3.png 703w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan ik teksten opmaken in Excel? Met voorwaardelijke opmaak, zoals getallen. A. Ja, dat kan. Een aantal dingen liggen voor de hand dubbele waarden laten markeren teksten\/cellen laten\u00c2\u00a0 markeren die een bepaalde tekst bevat Andere dingen kunnen ook groter dan \/ kleiner dan \/ tussen &#8211; houd er rekening<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":10,"footnotes":""},"categories":[375,79,10,160],"tags":[],"class_list":["post-2597","post","type-post","status-publish","format-standard","hentry","category-excel-office-2010","category-odisee","category-office","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 07:50:12","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\/2597","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=2597"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/2597\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=2597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=2597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=2597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}