{"id":13124,"date":"2017-06-01T16:36:07","date_gmt":"2017-06-01T16:36:07","guid":{"rendered":"http:\/\/www.mu.my\/?p=13124\/"},"modified":"2019-09-18T13:36:55","modified_gmt":"2019-09-18T13:36:55","slug":"conditional-formatting-excel","status":"publish","type":"post","link":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/","title":{"rendered":"Conditional Formatting in Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"13124\" class=\"elementor elementor-13124 elementor-13128 elementor-bc-flex-widget\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9775543 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9775543\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-de7f048\" data-id=\"de7f048\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d17a456 elementor-widget elementor-widget-image-gallery\" data-id=\"d17a456\" data-element_type=\"widget\" data-widget_type=\"image-gallery.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-image-gallery\">\n\t\t\t<div id='gallery-1' class='gallery galleryid-13124 gallery-columns-1 gallery-size-large'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"d17a456\" data-elementor-lightbox-title=\"excel (1)\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6Mjg5NzUsInVybCI6Imh0dHBzOlwvXC93d3cubXUubXlcL2ZpbGVzXC91cGxvYWRzXC9leGNlbC0xLTQucG5nIiwic2xpZGVzaG93IjoiZDE3YTQ1NiJ9\" href='https:\/\/www.mu.my\/files\/uploads\/excel-1-4.png'><img fetchpriority=\"high\" decoding=\"async\" width=\"560\" height=\"350\" src=\"https:\/\/www.mu.my\/files\/uploads\/excel-1-4.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/excel-1-4.png 560w, https:\/\/www.mu.my\/files\/uploads\/excel-1-4-300x188.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-82d5a02 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"82d5a02\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8c35bae\" data-id=\"8c35bae\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-43111d8 elementor-widget elementor-widget-text-editor\" data-id=\"43111d8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"s3\"><span class=\"s45\">Make your data easier to read.<\/span><\/p><p class=\"s3\"><span class=\"s45\">With Conditional Formatting, you can highlight the data with a certain colour or style based on cell values. For example, you can highlight the sales above RM8000 by creating a certain rule. You also can find duplicated items, hide errors, compare two lists,\u00a0<\/span><span class=\"s45\">etc. Conditional Formatting is a powerful feature and can do more than many people realize.<\/span><\/p><p>Want to learn more on Conditional Formatting in Excel, enroll with us\u00a0<a href=\"http:\/\/www.excel.my\/\" target=\"_blank\" rel=\"nofollow nofollow noopener noreferrer\">http:\/\/excel.my\/<\/a><\/p><p>Upcoming Excel Training Basic to Advance on 13-14 July 2017.<br \/>Contact <a href=\"mailto:info@mu.my\">info@mu.my<\/a> or 03-80116639.<br \/>Find out more at\u00a0<a href=\"http:\/\/www.mu.my\/en\/\" target=\"_blank\" rel=\"nofollow nofollow noopener noreferrer\">http:\/\/www.mu.my\/<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Make your data easier to read. With Conditional Formatting, you can highlight the data with a certain colour or style based on cell values. For example, you can highlight the sales above RM8000 by creating a certain rule. You also can find duplicated items, hide errors, compare two lists,&nbsp;etc. Conditional Formatting is a powerful feature &#8230; <a title=\"Conditional Formatting in Excel\" class=\"read-more\" href=\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/\" aria-label=\"Read more about Conditional Formatting in Excel\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":28969,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[153,154],"class_list":["post-13124","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news","tag-excel","tag-office"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Conditional Formatting in Excel - MU DOT MY PLT - ICT Training &amp; Development Malaysia<\/title>\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.mu.my\/en\/news\/conditional-formatting-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conditional Formatting in Excel - MU DOT MY PLT - ICT Training &amp; Development Malaysia\" \/>\n<meta property=\"og:description\" content=\"Make your data easier to read. With Conditional Formatting, you can highlight the data with a certain colour or style based on cell values. For example, you can highlight the sales above RM8000 by creating a certain rule. You also can find duplicated items, hide errors, compare two lists,&nbsp;etc. Conditional Formatting is a powerful feature ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"MU DOT MY PLT - ICT Training &amp; Development Malaysia\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/mudotmy\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-01T16:36:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-18T13:36:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"525\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sam S\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mudotmy\" \/>\n<meta name=\"twitter:site\" content=\"@mudotmy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sam S\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/\"},\"author\":{\"name\":\"Sam S\",\"@id\":\"https:\/\/www.mu.my\/en\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4\"},\"headline\":\"Conditional Formatting in Excel\",\"datePublished\":\"2017-06-01T16:36:07+00:00\",\"dateModified\":\"2019-09-18T13:36:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/\"},\"wordCount\":109,\"publisher\":{\"@id\":\"https:\/\/www.mu.my\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png\",\"keywords\":[\"Excel\",\"Office\"],\"articleSection\":[\"News\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/\",\"url\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/\",\"name\":\"Conditional Formatting in Excel - MU DOT MY PLT - ICT Training & Development Malaysia\",\"isPartOf\":{\"@id\":\"https:\/\/www.mu.my\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png\",\"datePublished\":\"2017-06-01T16:36:07+00:00\",\"dateModified\":\"2019-09-18T13:36:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#primaryimage\",\"url\":\"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png\",\"contentUrl\":\"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png\",\"width\":525,\"height\":350},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mu.my\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conditional Formatting in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.mu.my\/en\/#website\",\"url\":\"https:\/\/www.mu.my\/en\/\",\"name\":\"MU DOT MY PLT - ICT Training & Development Malaysia\",\"description\":\"extracting knowledge\",\"publisher\":{\"@id\":\"https:\/\/www.mu.my\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.mu.my\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.mu.my\/en\/#organization\",\"name\":\"MU DOT MY PLT\",\"url\":\"https:\/\/www.mu.my\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mu.my\/en\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/www.mu.my\/files\/uploads\/MU-logo.png\",\"contentUrl\":\"http:\/\/www.mu.my\/files\/uploads\/MU-logo.png\",\"width\":502,\"height\":476,\"caption\":\"MU DOT MY PLT\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/mudotmy\",\"https:\/\/x.com\/mudotmy\",\"https:\/\/instagram.com\/mudotmyplt\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.mu.my\/en\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4\",\"name\":\"Sam S\",\"url\":\"https:\/\/www.mu.my\/en\/author\/muadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conditional Formatting in Excel - MU DOT MY PLT - ICT Training & Development Malaysia","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.mu.my\/en\/news\/conditional-formatting-excel\/","og_locale":"en_US","og_type":"article","og_title":"Conditional Formatting in Excel - MU DOT MY PLT - ICT Training & Development Malaysia","og_description":"Make your data easier to read. With Conditional Formatting, you can highlight the data with a certain colour or style based on cell values. For example, you can highlight the sales above RM8000 by creating a certain rule. You also can find duplicated items, hide errors, compare two lists,&nbsp;etc. Conditional Formatting is a powerful feature ... Read more","og_url":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/","og_site_name":"MU DOT MY PLT - ICT Training & Development Malaysia","article_publisher":"https:\/\/facebook.com\/mudotmy","article_published_time":"2017-06-01T16:36:07+00:00","article_modified_time":"2019-09-18T13:36:55+00:00","og_image":[{"width":525,"height":350,"url":"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png","type":"image\/png"}],"author":"Sam S","twitter_card":"summary_large_image","twitter_creator":"@mudotmy","twitter_site":"@mudotmy","twitter_misc":{"Written by":"Sam S","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#article","isPartOf":{"@id":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/"},"author":{"name":"Sam S","@id":"https:\/\/www.mu.my\/en\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4"},"headline":"Conditional Formatting in Excel","datePublished":"2017-06-01T16:36:07+00:00","dateModified":"2019-09-18T13:36:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/"},"wordCount":109,"publisher":{"@id":"https:\/\/www.mu.my\/en\/#organization"},"image":{"@id":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png","keywords":["Excel","Office"],"articleSection":["News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/","url":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/","name":"Conditional Formatting in Excel - MU DOT MY PLT - ICT Training & Development Malaysia","isPartOf":{"@id":"https:\/\/www.mu.my\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png","datePublished":"2017-06-01T16:36:07+00:00","dateModified":"2019-09-18T13:36:55+00:00","breadcrumb":{"@id":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#primaryimage","url":"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png","contentUrl":"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png","width":525,"height":350},{"@type":"BreadcrumbList","@id":"https:\/\/www.mu.my\/en\/news\/conditional-formatting-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mu.my\/en\/"},{"@type":"ListItem","position":2,"name":"Conditional Formatting in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.mu.my\/en\/#website","url":"https:\/\/www.mu.my\/en\/","name":"MU DOT MY PLT - ICT Training & Development Malaysia","description":"extracting knowledge","publisher":{"@id":"https:\/\/www.mu.my\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mu.my\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.mu.my\/en\/#organization","name":"MU DOT MY PLT","url":"https:\/\/www.mu.my\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mu.my\/en\/#\/schema\/logo\/image\/","url":"http:\/\/www.mu.my\/files\/uploads\/MU-logo.png","contentUrl":"http:\/\/www.mu.my\/files\/uploads\/MU-logo.png","width":502,"height":476,"caption":"MU DOT MY PLT"},"image":{"@id":"https:\/\/www.mu.my\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/mudotmy","https:\/\/x.com\/mudotmy","https:\/\/instagram.com\/mudotmyplt"]},{"@type":"Person","@id":"https:\/\/www.mu.my\/en\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4","name":"Sam S","url":"https:\/\/www.mu.my\/en\/author\/muadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/posts\/13124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/comments?post=13124"}],"version-history":[{"count":12,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/posts\/13124\/revisions"}],"predecessor-version":[{"id":47886,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/posts\/13124\/revisions\/47886"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/media\/28969"}],"wp:attachment":[{"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/media?parent=13124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/categories?post=13124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/tags?post=13124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}