{"id":8290,"date":"2024-12-22T06:31:45","date_gmt":"2024-12-22T06:31:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-to-mau-o-khong-khoa-trong-excel\/"},"modified":"2024-12-22T06:31:45","modified_gmt":"2024-12-22T06:31:45","slug":"huong-dan-to-mau-o-khong-khoa-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-to-mau-o-khong-khoa-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u00f4 m\u00e0u \u00f4 kh\u00f4ng kh\u00f3a trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u v\u00e0o Excel, \u0111\u00f4i khi ta c\u1ea7n kh\u00f3a m\u1ed9t ph\u1ea7n d\u1eef li\u1ec7u \u0111\u1ec3 tr\u00e1nh vi\u1ec7c thao t\u00e1c nh\u1ea7m, \u0111\u1ed3ng th\u1eddi\u00a0m\u1edf ph\u1ea7n c\u00f2n l\u1ea1i \u0111\u1ec3 c\u00f3 th\u1ec3 ti\u1ebfn h\u00e0nh th\u00eam d\u1eef li\u1ec7u. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nh\u1eadn bi\u1ebft \u0111\u00e2u l\u00e0 \u00f4 c\u00f3 th\u1ec3 nh\u1eadp d\u1eef li\u1ec7u? V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng Conditional Formatting k\u1ebft h\u1ee3p h\u00e0m CELL t\u00f4 m\u00e0u \u00f4 kh\u00f4ng kh\u00f3a.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6767b250d393e\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-mau-o-bi-khoa-trong-excel.html#To_mau_thu_cong\" title=\"T\u00f4 m\u00e0u th\u1ee7 c\u00f4ng\">T\u00f4 m\u00e0u th\u1ee7 c\u00f4ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-mau-o-bi-khoa-trong-excel.html#Su_dung_Conditional_Formatting_ket_hop_ham_CELL_to_mau_o_khong_khoa\" title=\"S\u1eed d\u1ee5ng Conditional Formatting k\u1ebft h\u1ee3p h\u00e0m CELL t\u00f4 m\u00e0u \u00f4 kh\u00f4ng kh\u00f3a\">S\u1eed d\u1ee5ng Conditional Formatting k\u1ebft h\u1ee3p h\u00e0m CELL t\u00f4 m\u00e0u \u00f4 kh\u00f4ng kh\u00f3a<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-mau-o-bi-khoa-trong-excel.html#Ham_CELL_tra_ve_thong_tin_o_khoa_hay_khong\" title=\"H\u00e0m CELL tr\u1ea3 v\u1ec1 th\u00f4ng tin \u00f4 kh\u00f3a hay kh\u00f4ng\">H\u00e0m CELL tr\u1ea3 v\u1ec1 th\u00f4ng tin \u00f4 kh\u00f3a hay kh\u00f4ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-mau-o-bi-khoa-trong-excel.html#Thiet_lap_dieu_kien_Conditional_Formatting_bang_cong_thuc\" title=\"Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n Conditional Formatting b\u1eb1ng c\u00f4ng th\u1ee9c\">Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n Conditional Formatting b\u1eb1ng c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"To_mau_thu_cong\"><\/span>T\u00f4 m\u00e0u th\u1ee7 c\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta c\u00f3 v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28692\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/to-mau-o-khong-khoa-1.png\" width=\"581\" height=\"106\" title=\"to-mau-o-khong-khoa-1\"><\/p>\n<p><em>Y\u00eau c\u1ea7u: Hi\u1ec3n th\u1ecb \u00f4 \u0111\u01b0\u1ee3c ph\u00e9p nh\u1eadp<\/em><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ta c\u00f3 th\u1ec3 \u0111\u01a1n gi\u1ea3n th\u1ef1c hi\u1ec7n thao t\u00e1c \u0111\u1ed5 m\u00e0u cho \u00f4 b\u1eb1ng c\u00e1ch ch\u1ecdn\u00a0<strong>Fill Color<\/strong> trong th\u1ebb\u00a0<strong>Home.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28693\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/to-mau-o-khong-khoa-2.png\" width=\"609\" height=\"275\" title=\"to-mau-o-khong-khoa-2\"><\/p>\n<p>Tuy nhi\u00ean \u0111\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p ta t\u1ef1 \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng tay. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ed3ng lo\u1ea1i trong tr\u01b0\u1eddng h\u1ee3p nhi\u1ec1u d\u1eef li\u1ec7u h\u01a1n, \u0111\u1ed3ng th\u1eddi t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt theo s\u1ef1 thay \u0111\u1ed5i trong t\u00ecnh tr\u1ea1ng \u00f4? Ta s\u1ebd \u0111\u1ebfn v\u1edbi c\u00e1ch th\u1ee9 2.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-754.gif\" title=\"ex101_92019-nho-754\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_Conditional_Formatting_ket_hop_ham_CELL_to_mau_o_khong_khoa\"><\/span>S\u1eed d\u1ee5ng Conditional Formatting k\u1ebft h\u1ee3p h\u00e0m CELL t\u00f4 m\u00e0u \u00f4 kh\u00f4ng kh\u00f3a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>Xem tr\u01b0\u1edbc 2 b\u00e0i vi\u1ebft sau:<\/em><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/conditional-formatting-thao-tac-voi-ngay-thang-trong-excel.html\"><em><strong>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong Conditional Formatting \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng<\/strong><\/em><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ham-cell-thong-tin-o.html\"><strong><em>H\u00e0m CELL trong Excel<\/em><\/strong><\/a><\/p>\n<p>\u00a0<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 t\u00f4 m\u00e0u \u00f4 kh\u00f4ng kh\u00f3a trong Excel, ta s\u1ebd k\u1ebft h\u1ee3p 2 \u0111\u1ed1i t\u01b0\u1ee3ng:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ham_CELL_tra_ve_thong_tin_o_khoa_hay_khong\"><\/span>H\u00e0m CELL tr\u1ea3 v\u1ec1 th\u00f4ng tin \u00f4 kh\u00f3a hay kh\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ea7u ti\u00ean, v\u1edbi h\u00e0m CELL ta s\u1ebd t\u00ecm ra li\u1ec7u \u0111\u00e2y c\u00f3 ph\u1ea3i \u00f4 kh\u00f4ng kh\u00f3a kh\u00f4ng. V\u1edbi \u00f4 \u0111ang kh\u00f3a, h\u00e0m CELL s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 1. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 0 v\u1edbi \u00f4 kh\u00f4ng kh\u00f3a.<\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m CELL nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=CELL(\u201cprotect\u201d,\u0111\u1ecba ch\u1ec9 \u00f4)<\/strong><\/p>\n<\/blockquote>\n<p>\u0110\u01b0a v\u00e0o v\u00ed d\u1ee5 tr\u00ean, ta \u0111\u1eb7t d\u1eef li\u1ec7u cho \u00f4 A1 \u2013 \u00f4 m\u1edf \u0111\u1ea7u b\u1ea3ng t\u00ednh:\u00a0<em>=CELL(\u201cprotect\u201d,A1)<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28694\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/to-mau-o-khong-khoa-3.png\" width=\"646\" height=\"128\" title=\"to-mau-o-khong-khoa-3\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Thiet_lap_dieu_kien_Conditional_Formatting_bang_cong_thuc\"><\/span>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n Conditional Formatting b\u1eb1ng c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ea7u ti\u00ean ch\u1ecdn v\u00f9ng mu\u1ed1n thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c, ch\u1eb3ng h\u1ea1n \u1edf \u0111\u00e2y v\u00f9ng ta c\u1ea7n ch\u1ecdn l\u00e0 A1:B3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28695\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/to-mau-o-khong-khoa-4.png\" width=\"584\" height=\"84\" title=\"to-mau-o-khong-khoa-4\"><\/p>\n<p>T\u1ea1i th\u1ebb\u00a0<strong>Home<\/strong>, ch\u1ecdn\u00a0<strong>Conditional Formatting<\/strong> -&gt;\u00a0<strong>New Rule\u2026\u00a0<\/strong>-&gt;\u00a0<strong>Use a formula to determine which cells to format<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28696\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/to-mau-o-khong-khoa-5.png\" width=\"387\" height=\"369\" title=\"to-mau-o-khong-khoa-5\"><\/p>\n<p>Trong m\u1ee5c\u00a0<strong>Format values where this formula is true<\/strong>, \u0111\u01b0a c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m CELL v\u00e0o. B\u1edfi \u0111i\u1ec1u ki\u1ec7n l\u00e0 t\u00f4 m\u00e0u \u00f4 kh\u00f4ng kh\u00f3a, ta so s\u00e1nh v\u1edbi 0:<\/p>\n<p><em>=CELL(\u201cprotect\u201d,A1)=0<\/em><\/p>\n<p>Sau \u0111\u00f3 t\u1ea1i m\u1ee5c\u00a0<strong>Format\u2026<\/strong>, ch\u1ecdn m\u00e0u n\u1ec1n t\u00f9y \u00fd:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28697\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/to-mau-o-khong-khoa-6.png\" width=\"387\" height=\"372\" title=\"to-mau-o-khong-khoa-6\"><\/p>\n<p>\u1ea4n\u00a0<strong>OK<\/strong> \u0111\u1ec3 thi\u1ebft l\u1eadp. Ta c\u00f3 k\u1ebft qu\u1ea3 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28698\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/to-mau-o-khong-khoa-7.png\" width=\"582\" height=\"83\" title=\"to-mau-o-khong-khoa-7\"><\/p>\n<p>\u00d4 B1 trong v\u00ed d\u1ee5 \u0111\u1ea7u ti\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ecf kh\u00f3a, tuy nhi\u00ean \u00f4 B2 v\u00e0 B3 th\u00ec ch\u01b0a. Ta s\u1ebd v\u00e0o\u00a0<strong>Format Cell\u00a0<\/strong>(ph\u00edm t\u1eaft\u00a0<strong>Ctrl 1<\/strong>) \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh tr\u1ea1ng th\u00e1i cho 2 \u00f4 c\u00f2n l\u1ea1i. Khi \u0111\u00f3 Conditional Formatting s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28699\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/to-mau-o-khong-khoa-8.png\" width=\"530\" height=\"467\" title=\"to-mau-o-khong-khoa-8\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28700\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/to-mau-o-khong-khoa-9.png\" width=\"578\" height=\"84\" title=\"to-mau-o-khong-khoa-9\"><\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/bao-ve-trang-tinh-voi-chuc-nang-protect-sheet.html\">B\u1ea3o v\u1ec7 trang t\u00ednh v\u1edbi ch\u1ee9c n\u0103ng Protect Sheet<\/a><\/strong><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html\">S\u1eeda file Excel n\u1eb7ng ch\u1eadm, g\u1ee1 b\u1ecf m\u1eadt kh\u1ea9u<\/a><\/strong><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-754.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8291,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8290","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8290"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8290\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8291"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}