{"id":8502,"date":"2023-01-12T18:21:47","date_gmt":"2023-01-12T18:21:47","guid":{"rendered":"https:\/\/www.markwilson.co.uk\/blog\/?p=8502"},"modified":"2023-03-29T21:37:51","modified_gmt":"2023-03-29T20:37:51","slug":"formatting-cells-in-excel-if-they-match-a-value-in-another-column","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm","title":{"rendered":"Formatting cells in Excel if they match a value in another column"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A few months ago, I wrote about <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2022\/05\/sorting-a-word-table-of-names-in-excel.htm\">using Excel to sort a table of names that had been created in Word<\/a>. And last year, <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2021\/11\/step-back-from-the-problem-and-think-about-what-good-looks-like.htm\">I mentioned a dynamic report I&#8217;d created with a colleague<\/a>, stringing together a few formulae, some data validation and some conditionally formatted cells. Well, today, that same colleague came to me and asked to borrow my Excel skills again.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">He had a list of potential sales opportunities and wanted to highlight any cells in the column of client names that matched a list of primary accounts on another sheet. It sounded &#8220;do-able&#8221;, with some conditional formatting and a formula.   <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I like a challenge &#8211; and it&#8217;s as close to any development work as I get these days &#8211; so I got stuck in.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It seems the function I needed was <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a\"><code>=MATCH()<\/code><\/a> although now I&#8217;m wondering if <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1\"><code>=VLOOKUP()<\/code><\/a> might have been more appropriate.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The actual formula used in my conditional formatting rule (applied to data in column E) was this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=MATCH($E2,'Primary Account List'!$A$4:$A$34,0)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Basically, it&#8217;s saying, for the value in this cell, have a look at the data in the Primary Account List sheet, cells A4-A34 and if there&#8217;s a match, apply the formatting (bold, orange). I did put $E1 in at first, and the lookup was one cell out&#8230; (row 1 is the column headers). E2 is the start of my list but the same formula is used in the conditional formatting rule that covers all the cells.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Featured image: author&#8217;s own.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A few months ago, I wrote about using Excel to sort a table of names that had been created in Word. And last year, I mentioned a dynamic report I&#8217;d created with a colleague, stringing together a few formulae, some data validation and some conditionally formatted cells. Well, today, that same colleague came to me &hellip; <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Formatting cells in Excel if they match a value in another column<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":8503,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[218],"tags":[188],"class_list":["post-8502","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Formatting cells in Excel if they match a value in another column - markwilson.it<\/title>\n<meta name=\"description\" content=\"Using the =MATCH() function in Excel to compare data with values in another column and apply conditional formatting\" \/>\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.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formatting cells in Excel if they match a value in another column - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"Using the =MATCH() function in Excel to compare data with values in another column and apply conditional formatting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-12T18:21:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-29T20:37:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"771\" \/>\n\t<meta property=\"og:image:height\" content=\"553\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Mark Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:site\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"Formatting cells in Excel if they match a value in another column\",\"datePublished\":\"2023-01-12T18:21:47+00:00\",\"dateModified\":\"2023-03-29T20:37:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm\"},\"wordCount\":259,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1\",\"keywords\":[\"Microsoft Excel\"],\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm\",\"name\":\"Formatting cells in Excel if they match a value in another column - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1\",\"datePublished\":\"2023-01-12T18:21:47+00:00\",\"dateModified\":\"2023-03-29T20:37:51+00:00\",\"description\":\"Using the =MATCH() function in Excel to compare data with values in another column and apply conditional formatting\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1\",\"width\":771,\"height\":553},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2023\\\/01\\\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formatting cells in Excel if they match a value in another column\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/\",\"name\":\"markwilson.it\",\"description\":\"get-info -class technology | write-output &gt; \\\/dev\\\/web\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\",\"name\":\"Mark Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"width\":800,\"height\":800,\"caption\":\"Mark Wilson\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\"},\"description\":\"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.\",\"sameAs\":[\"http:\\\/\\\/www.markwilson.co.uk\\\/\",\"https:\\\/\\\/www.instagram.com\\\/markwilsonuk\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/markawilson\\\/\",\"https:\\\/\\\/x.com\\\/markwilsonit\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCWHlZCoHRTocdvtrOJ2IL4A\"],\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/author\\\/mark-wilson\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formatting cells in Excel if they match a value in another column - markwilson.it","description":"Using the =MATCH() function in Excel to compare data with values in another column and apply conditional formatting","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.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm","og_locale":"en_GB","og_type":"article","og_title":"Formatting cells in Excel if they match a value in another column - markwilson.it","og_description":"Using the =MATCH() function in Excel to compare data with values in another column and apply conditional formatting","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm","og_site_name":"markwilson.it","article_published_time":"2023-01-12T18:21:47+00:00","article_modified_time":"2023-03-29T20:37:51+00:00","og_image":[{"width":771,"height":553,"url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1","type":"image\/png"}],"author":"Mark Wilson","twitter_card":"summary_large_image","twitter_creator":"@markwilsonit","twitter_site":"@markwilsonit","twitter_misc":{"Written by":"Mark Wilson","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"Formatting cells in Excel if they match a value in another column","datePublished":"2023-01-12T18:21:47+00:00","dateModified":"2023-03-29T20:37:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm"},"wordCount":259,"commentCount":0,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1","keywords":["Microsoft Excel"],"articleSection":["Technology"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm","name":"Formatting cells in Excel if they match a value in another column - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#primaryimage"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1","datePublished":"2023-01-12T18:21:47+00:00","dateModified":"2023-03-29T20:37:51+00:00","description":"Using the =MATCH() function in Excel to compare data with values in another column and apply conditional formatting","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#primaryimage","url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1","width":771,"height":553},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Formatting cells in Excel if they match a value in another column"}]},{"@type":"WebSite","@id":"https:\/\/www.markwilson.co.uk\/blog\/#website","url":"https:\/\/www.markwilson.co.uk\/blog\/","name":"markwilson.it","description":"get-info -class technology | write-output &gt; \/dev\/web","publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.markwilson.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468","name":"Mark Wilson","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","width":800,"height":800,"caption":"Mark Wilson"},"logo":{"@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1"},"description":"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.","sameAs":["http:\/\/www.markwilson.co.uk\/","https:\/\/www.instagram.com\/markwilsonuk\/","https:\/\/www.linkedin.com\/in\/markawilson\/","https:\/\/x.com\/markwilsonit","https:\/\/www.youtube.com\/channel\/UCWHlZCoHRTocdvtrOJ2IL4A"],"url":"https:\/\/www.markwilson.co.uk\/blog\/author\/mark-wilson"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1","jetpack-related-posts":[{"id":4682,"url":"https:\/\/www.markwilson.co.uk\/blog\/2013\/01\/formulas-shown-in-excel-instead-of-the-results.htm","url_meta":{"origin":8502,"position":0},"title":"Formulas shown in Excel, instead of their results","author":"Mark Wilson","date":"Wednesday 2 January 2013","format":false,"excerpt":"Every month or so, I have to create a report which is extracted from SharePoint to Excel, and then a couple of extra columns are added with information required by a colleague. The additional columns simply present existing information in a different format but, for some reason, after pasting in\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5192,"url":"https:\/\/www.markwilson.co.uk\/blog\/2014\/04\/fighting-with-formulae-in-excel.htm","url_meta":{"origin":8502,"position":1},"title":"Fighting with formulae in Excel","author":"Mark Wilson","date":"Tuesday 22 April 2014","format":false,"excerpt":"Excel. Love it, or hate it, there are few of us in white collar jobs who don't have to grapple with it from time to time and, earlier this evening, after OneNote had yet again decided that syncing shared notebooks via our ageing SharePoint platform as not going to work,\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4965,"url":"https:\/\/www.markwilson.co.uk\/blog\/2013\/07\/business-intelligence-required.htm","url_meta":{"origin":8502,"position":2},"title":"Business intelligence required&#8230;","author":"Mark Wilson","date":"Tuesday 16 July 2013","format":false,"excerpt":"Up and down the country, businesses are running on Excel, instead of using a proper business intelligence (or even management information) system. The one I look after is no different but, as I pieced together yet another spreadsheet last weekend, I learned a few Excel tips that might be useful\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5508,"url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm","url_meta":{"origin":8502,"position":3},"title":"Excel formula for calculating a price, based on a known cost and margin percentage","author":"Mark Wilson","date":"Wednesday 18 March 2015","format":false,"excerpt":"A couple of years ago, I blogged about the difference between margin and markup. Since then, there have been a number of occasions when I've wanted to know the formula to take two cells in Excel, one with a cost and the other with a margin\u00a0percentage, and then calculate the\u2026","rel":"","context":"In &quot;Waffle and randomness&quot;","block_context":{"text":"Waffle and randomness","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/inane-waffle"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/excel-margin.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":5805,"url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-excel-tips-display-worksheet-name-validate-data-editing-microsoft-project-files-stored-sharepoint-xps-pdf-conversion-service.htm","url_meta":{"origin":8502,"position":4},"title":"Short takes: Excel tips to display the worksheet name and validate data; editing Microsoft Project files stored on SharePoint; and an XPS to PDF conversion service","author":"Mark Wilson","date":"Monday 17 August 2015","format":false,"excerpt":"Another collection of mini-posts based on recent IT trials and tribulations... Excel tips to display the worksheet name in a cell\u00a0and to validate data Last week, I was working on an Excel spreadsheet that acts as a plan for a series of tests. Each sheet has the same format, with\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5649,"url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/05\/short-takes-symbols-in-office-applications-and-converting-numbers-to-text-in-excel.htm","url_meta":{"origin":8502,"position":5},"title":"Short takes: Symbols in Office applications and converting numbers to text in Excel","author":"Mark Wilson","date":"Sunday 17 May 2015","format":false,"excerpt":"A few snippets I found on scraps of paper whilst sorting\u00a0out my office this\u00a0week... Shortcuts to\u00a0symbols in Office applications Many people will be familiar with typing (c) to generate a \u00a9 symbol in Microsoft Office applications but you can also use (R) or (TM) for trademark symbols \u00ae and \u2122.\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/8502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=8502"}],"version-history":[{"count":2,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/8502\/revisions"}],"predecessor-version":[{"id":8511,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/8502\/revisions\/8511"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media\/8503"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=8502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=8502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=8502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}