{"id":2399,"date":"2022-11-10T08:35:15","date_gmt":"2022-11-10T08:35:15","guid":{"rendered":"https:\/\/www.bjorn-meijer.nl\/?p=2399"},"modified":"2022-11-14T19:01:32","modified_gmt":"2022-11-14T19:01:32","slug":"highlight-geselecteerde-rij-in-excel","status":"publish","type":"post","link":"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/10\/highlight-selected-row-in-excel\/","title":{"rendered":"Highlight selected row in Excel"},"content":{"rendered":"<p>Certainly with large datasets, it can be an advantage to give the activated row (and possibly column) a different background color. Using <strong>Conditional formatting<\/strong> and a simple <strong>VBA script<\/strong> (macro) this is possible in Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-voorwaardelijke-opmaak\">Conditional formatting<\/h2>\n\n\n\n<p>Let&#039;s start with the formula we are going to use for the conditional formatting.<br>The formula we are going to use to highlight the active row consists of two functions and is as follows:<\/p>\n\n\n\n<pre id=\"formule\" class=\"wp-block-code\"><code>=ROW()=CELL(&quot;row&quot;)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">How the functions work<\/h2>\n\n\n\n<p>The ROW() function returns the row number of the cell in which the function was entered. If you enter the =ROW() function in cell J4, it will return 4 as a result.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"946\" height=\"453\" src=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Excel-functie-RIJ.gif\" alt=\"Excel function ROW()\" class=\"wp-image-2405\"\/><figcaption class=\"wp-element-caption\">Excel function ROW()<\/figcaption><\/figure>\n\n\n\n<p>The CELL() function returns information about the formatting, content, or location of the selected cell. With this function you indicate in an argument what information you want to know about the selected cell. It will then be returned in the cell where you entered the function.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"946\" height=\"453\" src=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Excel-functie-CEL.gif\" alt=\"Excel function CELL()\" class=\"wp-image-2407\"\/><figcaption class=\"wp-element-caption\">Excel function CELL()<\/figcaption><\/figure>\n\n\n\n<p>Selecting a cell and recalculating the formulas in your worksheet updates the value in the cell. You do this by pressing the function key <strong>F9<\/strong> or navigating in the Ribbon menu to the tab <strong>Formulas<i class=\"fas fa-arrow-right\"><\/i>Calculation<i class=\"fas fa-arrow-right\"><\/i><\/strong> and click <strong>Calculate now<\/strong>. Recalculates the formulas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Explanation formula<\/h2>\n\n\n\n<p>If we <a href=\"#formule\">above formula<\/a> view there is the following. If the result of the ROW() function is the same as the result of the CELL(&quot;row&quot;) function, then the formula is TRUE. If the condition is not met, the result of the formula is FALSE.<\/p>\n\n\n\n<p>If the result of the formula is TRUE, the background color of the row should be colored.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Formatting conditional formatting<\/h2>\n\n\n\n<p>Select the range of your data table.<\/p>\n\n\n\n<p>In the Ribbon menu go to <strong>Start<i class=\"fas fa-arrow-right\"><\/i>Styles<i class=\"fas fa-arrow-right\"><\/i>Conditional formatting<\/strong>.<\/p>\n\n\n\n<p>click on <strong>New rule\u2026<\/strong>.<\/p>\n\n\n\n<p>A new window will open called <strong>New Formatting Rule<\/strong>.<\/p>\n\n\n\n<p>Select the line <strong>Use a formula to control which cells are formatted<\/strong>.<\/p>\n\n\n\n<p>Enter the following formula in the formula bar:<\/p>\n\n\n\n<p><code>=ROW()=CELL(&quot;row&quot;)<\/code><\/p>\n\n\n\n<p>Then click the button <strong><span style=\"text-decoration: underline;\">O<\/span>pmaak.<\/strong> <\/p>\n\n\n\n<p>A new window will open <strong>Format cells<\/strong>.<\/p>\n\n\n\n<p>Go to the tab <strong>padding<\/strong>, select the desired background color and click <strong>OK<\/strong>.<\/p>\n\n\n\n<p>After the window <strong>Format cells<\/strong> is closed, close the window <strong>New Formatting Rule<\/strong> by op <strong>OK<\/strong> to click.<\/p>\n\n\n\n<p>Select a line in your data table and recalculate the formulas in your worksheet by pressing the function key <strong>F9<\/strong> pressing or navigating to the tab <strong>Formulas<i class=\"fas fa-arrow-right\"><\/i>Calculation<i class=\"fas fa-arrow-right\"><\/i>Calculate now<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1226\" height=\"1038\" src=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Excel-Highligt-geselecteerde-rij-in-datatabel.gif\" alt=\"Highlight selected row in data table\" class=\"wp-image-2410\"\/><figcaption class=\"wp-element-caption\">Highlight selected row in data table<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-macro-maken-in-de-vba-editor\">Create macro in the VBA editor<\/h2>\n\n\n\n<p>To have the formulas automatically recalculated after each selection change, we use a macro with the VBA editor.<\/p>\n\n\n\n<p>To open the VBA editor, press the function key <strong>Alt+F9<\/strong>. After which the VBA editor opens.<\/p>\n\n\n\n<p>On the left side of your screen, select the sheet in which you have the conditional formatting.<\/p>\n\n\n\n<p>Above the VBA editor, click the left drop-down menu and choose <strong>Worksheet<\/strong>.<\/p>\n\n\n\n<p>A subroutine is automatically created called <code>Worksheet_SelectionChange(ByVal Target As Range)<\/code>.<\/p>\n\n\n\n<p>Enter the code below in the VBA editor:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\"><pre class=\"brush: vb; title: ; notranslate\" title=\"\">\nPrivate Sub Worksheet_SelectionChange(ByVal Target As Range) If Application.CutCopyMode = False Then ActiveSheet.Application.Calculate End If End Sub\n<\/pre><\/div>\n\n\n<p>Close the VBA editor and select a few different lines in your data table to see if the VBA script works properly.<\/p>\n\n\n\n<p>Save the file as an Excel workbook with macros.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1226\" height=\"1038\" src=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/VBA-editor-Worksheet_SelectionChange.gif\" alt=\"VBA editor Worksheet_SelectionChange\" class=\"wp-image-2411\"\/><figcaption class=\"wp-element-caption\">VBA editor Worksheet_SelectionChange<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Explanation of how VBA script works<\/h2>\n\n\n\n<p>With the IF statement we check whether values are being cut or pasted from the data table. If this is not the case, the formulas are updated by means of the code <code>ActiveSheet.Application.Calculate<\/code>.<\/p>\n\n\n\n<p>If we don&#039;t apply the IF statement, it would not be possible to copy and paste values. Hence this piece of code.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Adjust background color of selected column <\/h2>\n\n\n\n<p>Do you (also) want to give the background of the selected column a different background color? Then enter the following formula in the conditional format:<\/p>\n\n\n\n<p><code>=COLUMN()=CELL(&quot;column&quot;)<\/code><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"downloads\"> <i class=\"fas fa-download\"><\/i> Downloads <\/h2>\n\n\n\n<p>If you can&#039;t figure it out with the above guide alone, download the sample file or ask a question by leaving a message.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-9c0ef70b-7530-436f-80b3-28377bb69cfe\" href=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Highlight-geselecteerde-rij.zip\">Highlight selected row<\/a><a href=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Highlight-geselecteerde-rij.zip\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-9c0ef70b-7530-436f-80b3-28377bb69cfe\"><i class=\"fas fa-file-download\"><\/i> Download<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>Especially with large datasets, it can be an advantage to give the activated row (and possibly column) a different background color\u2026 <a class=\"read-more\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/10\/highlight-selected-row-in-excel\/\">Continue reading<\/a><\/p>","protected":false},"author":1,"featured_media":265,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7,8,45],"tags":[17,21,18,34,99,22,100],"class_list":["post-2399","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-formules","category-vba","tag-excel","tag-excel-functies","tag-formules","tag-macro","tag-rij","tag-vba","tag-voorwaardelijke-opmaak"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.11 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Highlight geselecteerde rij in Excel - Bj\u00f6rn Meijer<\/title>\n<meta name=\"description\" content=\"Geef de geactiveerde rij (en eventueel kolom) een andere achtergrondkleur waardoor dataset leesbaarder wordt.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/10\/highlight-selected-row-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Highlight geselecteerde rij in Excel\" \/>\n<meta property=\"og:description\" content=\"Zeker bij grote datasets kan het een voordeel hebben om de geactiveerde rij (en eventueel kolom) een andere achtergrondkleur te geven. Met behulp van\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/10\/highlight-selected-row-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-10T08:35:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-14T19:01:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bj\u00f6rn Meijer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/\"},\"author\":{\"name\":\"Bj\u00f6rn Meijer\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"headline\":\"Highlight geselecteerde rij in Excel\",\"datePublished\":\"2022-11-10T08:35:15+00:00\",\"dateModified\":\"2022-11-14T19:01:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/\"},\"wordCount\":693,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"keywords\":[\"excel\",\"excel functies\",\"formules\",\"Macro\",\"RIJ()\",\"vba\",\"voorwaardelijke opmaak\"],\"articleSection\":[\"Excel\",\"Excel formules\",\"VBA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/\",\"name\":\"Highlight geselecteerde rij in Excel - Bj\u00f6rn Meijer\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"datePublished\":\"2022-11-10T08:35:15+00:00\",\"dateModified\":\"2022-11-14T19:01:32+00:00\",\"description\":\"Geef de geactiveerde rij (en eventueel kolom) een andere achtergrondkleur waardoor dataset leesbaarder wordt.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#primaryimage\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"contentUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"width\":300,\"height\":300,\"caption\":\"Microsoft Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bjorn-meijer.nl\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Highlight geselecteerde rij in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/de\/\",\"name\":\"Bj\u00f6rn Meijer\",\"description\":\"At My Playground\",\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\",\"name\":\"Bj\u00f6rn Meijer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"width\":165,\"height\":165,\"caption\":\"Bj\u00f6rn Meijer\"},\"logo\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.bjorn-meijer.nl\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Highlight geselecteerde rij in Excel - Bj\u00f6rn Meijer","description":"Geef de geactiveerde rij (en eventueel kolom) een andere achtergrondkleur waardoor dataset leesbaarder wordt.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/10\/highlight-selected-row-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Highlight geselecteerde rij in Excel","og_description":"Zeker bij grote datasets kan het een voordeel hebben om de geactiveerde rij (en eventueel kolom) een andere achtergrondkleur te geven. Met behulp van","og_url":"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/10\/highlight-selected-row-in-excel\/","og_site_name":"Bj\u00f6rn Meijer","article_published_time":"2022-11-10T08:35:15+00:00","article_modified_time":"2022-11-14T19:01:32+00:00","og_image":[{"width":300,"height":300,"url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","type":"image\/png"}],"author":"Bj\u00f6rn Meijer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bj\u00f6rn Meijer","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/"},"author":{"name":"Bj\u00f6rn Meijer","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"headline":"Highlight geselecteerde rij in Excel","datePublished":"2022-11-10T08:35:15+00:00","dateModified":"2022-11-14T19:01:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/"},"wordCount":693,"commentCount":2,"publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","keywords":["excel","excel functies","formules","Macro","RIJ()","vba","voorwaardelijke opmaak"],"articleSection":["Excel","Excel formules","VBA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/","url":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/","name":"Highlight geselecteerde rij in Excel - Bj\u00f6rn Meijer","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","datePublished":"2022-11-10T08:35:15+00:00","dateModified":"2022-11-14T19:01:32+00:00","description":"Geef de geactiveerde rij (en eventueel kolom) een andere achtergrondkleur waardoor dataset leesbaarder wordt.","breadcrumb":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#primaryimage","url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","contentUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","width":300,"height":300,"caption":"Microsoft Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/10\/highlight-geselecteerde-rij-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bjorn-meijer.nl\/de\/"},{"@type":"ListItem","position":2,"name":"Highlight geselecteerde rij in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website","url":"https:\/\/www.bjorn-meijer.nl\/de\/","name":"Bj\u00f6rn Meijer","description":"At My Playground","publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615","name":"Bj\u00f6rn Meijer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","width":165,"height":165,"caption":"Bj\u00f6rn Meijer"},"logo":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.bjorn-meijer.nl"]}]}},"jetpack_featured_media_url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/2399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/comments?post=2399"}],"version-history":[{"count":10,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/2399\/revisions"}],"predecessor-version":[{"id":2427,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/2399\/revisions\/2427"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media\/265"}],"wp:attachment":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media?parent=2399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/categories?post=2399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/tags?post=2399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}