{"id":13128,"date":"2017-06-01T16:36:07","date_gmt":"2017-06-01T16:36:07","guid":{"rendered":"http:\/\/www.mu.my\/conditional-formatting-excel\/"},"modified":"2020-03-13T08:11:37","modified_gmt":"2020-03-13T08:11:37","slug":"conditional-formatting-excel","status":"publish","type":"post","link":"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/","title":{"rendered":"Conditional Formatting dalam Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"13128\" class=\"elementor 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-7e37bba2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7e37bba2\" 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-3366fc75\" data-id=\"3366fc75\" 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-8663685 elementor-widget elementor-widget-image-gallery\" data-id=\"8663685\" 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-13128 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=\"8663685\" data-elementor-lightbox-title=\"excel (1)\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6Mjg5NzQsInVybCI6Imh0dHBzOlwvXC93d3cubXUubXlcL2ZpbGVzXC91cGxvYWRzXC9leGNlbC0xLTQucG5nIiwic2xpZGVzaG93IjoiODY2MzY4NSJ9\" 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-196a57b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"196a57b\" 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-d3136c5\" data-id=\"d3136c5\" 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-87a9f67 elementor-widget elementor-widget-text-editor\" data-id=\"87a9f67\" 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>Menjadikan data anda lebih mudah untuk dibaca.<\/p><p>Dengan Conditional Formatting, anda boleh menyerlahkan data dengan warna dan gaya berdasarkan nilai sel tertentu. Sebagai contoh, anda boleh menyerlahkan jualan melebihi RM8000 dengan mencipta peraturan tertentu. Anda juga boleh mencari item yang serupa, sembunyikan kesilapan, bandingkan dua senarai, dan sebagainya. Conditional Formatting ini adalah ciri yang hebat didalam Excel dan boleh melakukan lebih lagi dari ramai orang menyedarinya.<\/p><p>Ingin mengetahui lebih lanjut mengenai Conditional Formatting dalam Excel, mendaftar dengan kami\u00a0<a href=\"http:\/\/www.excel.my\/\">http:\/\/www.excel.my\/<\/a><\/p><p>Kursus Excel akan datang Asas ke Lanjutan pada 13-14 Julai 2017.<br \/>Hubungi\u00a0<a href=\"mailto:info@excel.my\">info@mu.my<\/a>\u00a0atau 03-80116639.<br \/>Dapatkan maklumat lanjut di\u00a0<a href=\"http:\/\/www.mu.my\/ms\/\">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>Menjadikan data anda lebih mudah untuk dibaca. Dengan Conditional Formatting, anda boleh menyerlahkan data dengan warna dan gaya berdasarkan nilai sel tertentu. Sebagai contoh, anda boleh menyerlahkan jualan melebihi RM8000 dengan mencipta peraturan tertentu. Anda juga boleh mencari item yang serupa, sembunyikan kesilapan, bandingkan dua senarai, dan sebagainya. Conditional Formatting ini adalah ciri yang hebat &#8230; <a title=\"Conditional Formatting dalam Excel\" class=\"read-more\" href=\"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/\" aria-label=\"Read more about Conditional Formatting dalam Excel\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":28970,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[178],"tags":[],"class_list":["post-13128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-berita"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Conditional Formatting dalam 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\/ms\/berita\/conditional-formatting-excel\/\" \/>\n<meta property=\"og:locale\" content=\"ms_MY\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conditional Formatting dalam Excel - MU DOT MY PLT - ICT Training &amp; Development Malaysia\" \/>\n<meta property=\"og:description\" content=\"Menjadikan data anda lebih mudah untuk dibaca. Dengan Conditional Formatting, anda boleh menyerlahkan data dengan warna dan gaya berdasarkan nilai sel tertentu. Sebagai contoh, anda boleh menyerlahkan jualan melebihi RM8000 dengan mencipta peraturan tertentu. Anda juga boleh mencari item yang serupa, sembunyikan kesilapan, bandingkan dua senarai, dan sebagainya. Conditional Formatting ini adalah ciri yang hebat ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mu.my\/ms\/berita\/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=\"2020-03-13T08:11:37+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 minit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/\"},\"author\":{\"name\":\"Sam S\",\"@id\":\"https:\/\/www.mu.my\/ms\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4\"},\"headline\":\"Conditional Formatting dalam Excel\",\"datePublished\":\"2017-06-01T16:36:07+00:00\",\"dateModified\":\"2020-03-13T08:11:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/\"},\"wordCount\":114,\"publisher\":{\"@id\":\"https:\/\/www.mu.my\/ms\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png\",\"articleSection\":[\"Berita\"],\"inLanguage\":\"ms-MY\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/\",\"url\":\"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/\",\"name\":\"Conditional Formatting dalam Excel - MU DOT MY PLT - ICT Training & Development Malaysia\",\"isPartOf\":{\"@id\":\"https:\/\/www.mu.my\/ms\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/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\":\"2020-03-13T08:11:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/#breadcrumb\"},\"inLanguage\":\"ms-MY\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/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\/ms\/berita\/conditional-formatting-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mu.my\/ms\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conditional Formatting dalam Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.mu.my\/ms\/#website\",\"url\":\"https:\/\/www.mu.my\/ms\/\",\"name\":\"MU DOT MY PLT - ICT Training & Development Malaysia\",\"description\":\"extracting knowledge\",\"publisher\":{\"@id\":\"https:\/\/www.mu.my\/ms\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.mu.my\/ms\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ms-MY\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.mu.my\/ms\/#organization\",\"name\":\"MU DOT MY PLT\",\"url\":\"https:\/\/www.mu.my\/ms\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\/\/www.mu.my\/ms\/#\/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\/ms\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/mudotmy\",\"https:\/\/x.com\/mudotmy\",\"https:\/\/instagram.com\/mudotmyplt\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.mu.my\/ms\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4\",\"name\":\"Sam S\",\"url\":\"https:\/\/www.mu.my\/ms\/author\/muadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conditional Formatting dalam 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\/ms\/berita\/conditional-formatting-excel\/","og_locale":"ms_MY","og_type":"article","og_title":"Conditional Formatting dalam Excel - MU DOT MY PLT - ICT Training & Development Malaysia","og_description":"Menjadikan data anda lebih mudah untuk dibaca. Dengan Conditional Formatting, anda boleh menyerlahkan data dengan warna dan gaya berdasarkan nilai sel tertentu. Sebagai contoh, anda boleh menyerlahkan jualan melebihi RM8000 dengan mencipta peraturan tertentu. Anda juga boleh mencari item yang serupa, sembunyikan kesilapan, bandingkan dua senarai, dan sebagainya. Conditional Formatting ini adalah ciri yang hebat ... Read more","og_url":"https:\/\/www.mu.my\/ms\/berita\/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":"2020-03-13T08:11:37+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 minit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/#article","isPartOf":{"@id":"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/"},"author":{"name":"Sam S","@id":"https:\/\/www.mu.my\/ms\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4"},"headline":"Conditional Formatting dalam Excel","datePublished":"2017-06-01T16:36:07+00:00","dateModified":"2020-03-13T08:11:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/"},"wordCount":114,"publisher":{"@id":"https:\/\/www.mu.my\/ms\/#organization"},"image":{"@id":"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mu.my\/files\/uploads\/Conditional-Formatting-Symbols-blog-icon-1-1.png","articleSection":["Berita"],"inLanguage":"ms-MY"},{"@type":"WebPage","@id":"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/","url":"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/","name":"Conditional Formatting dalam Excel - MU DOT MY PLT - ICT Training & Development Malaysia","isPartOf":{"@id":"https:\/\/www.mu.my\/ms\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.mu.my\/ms\/berita\/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":"2020-03-13T08:11:37+00:00","breadcrumb":{"@id":"https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/#breadcrumb"},"inLanguage":"ms-MY","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mu.my\/ms\/berita\/conditional-formatting-excel\/"]}]},{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/www.mu.my\/ms\/berita\/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\/ms\/berita\/conditional-formatting-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mu.my\/ms\/"},{"@type":"ListItem","position":2,"name":"Conditional Formatting dalam Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.mu.my\/ms\/#website","url":"https:\/\/www.mu.my\/ms\/","name":"MU DOT MY PLT - ICT Training & Development Malaysia","description":"extracting knowledge","publisher":{"@id":"https:\/\/www.mu.my\/ms\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mu.my\/ms\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ms-MY"},{"@type":"Organization","@id":"https:\/\/www.mu.my\/ms\/#organization","name":"MU DOT MY PLT","url":"https:\/\/www.mu.my\/ms\/","logo":{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/www.mu.my\/ms\/#\/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\/ms\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/mudotmy","https:\/\/x.com\/mudotmy","https:\/\/instagram.com\/mudotmyplt"]},{"@type":"Person","@id":"https:\/\/www.mu.my\/ms\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4","name":"Sam S","url":"https:\/\/www.mu.my\/ms\/author\/muadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts\/13128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/comments?post=13128"}],"version-history":[{"count":8,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts\/13128\/revisions"}],"predecessor-version":[{"id":62247,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts\/13128\/revisions\/62247"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/media\/28970"}],"wp:attachment":[{"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/media?parent=13128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/categories?post=13128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/tags?post=13128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}