1.0MU DOT MY PLT - ICT Training & Development Malaysiahttps://www.mu.my/ms/Conditional Formatting dalam Excel - MU DOT MY PLT - ICT Training & Development Malaysiarich600338<blockquote class="wp-embedded-content" data-secret="ttyaBefGut"><a href="https://www.mu.my/ms/berita/conditional-formatting-excel/">Conditional Formatting dalam Excel</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.mu.my/ms/berita/conditional-formatting-excel/embed/#?secret=ttyaBefGut" width="600" height="338" title="“Conditional Formatting dalam Excel” — MU DOT MY PLT - ICT Training & Development Malaysia" data-secret="ttyaBefGut" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script>
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
</script>
https://www.mu.my/files/uploads/Conditional-Formatting-Symbols-blog-icon-1-1.png525350Menjadikan 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