{"id":5750,"date":"2024-12-20T20:33:55","date_gmt":"2024-12-20T20:33:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/huong-dan-3-cach-dem-so-o-duoc-to-mau-trong-excel\/"},"modified":"2024-12-20T20:33:55","modified_gmt":"2024-12-20T20:33:55","slug":"huong-dan-3-cach-dem-so-o-duoc-to-mau-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/huong-dan-3-cach-dem-so-o-duoc-to-mau-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 3 c\u00e1ch \u0111\u1ebfm s\u1ed1 \u00f4 \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Vi\u1ec7c s\u1eed d\u1ee5ng m\u00e0u s\u1eafc \u0111\u1ec3 ph\u00e2n bi\u1ec7t c\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi \u01b0a th\u00edch s\u1eed d\u1ee5ng. Nh\u01b0ng b\u1ea1n kh\u00f4ng th\u1ec3 d\u00f9ng h\u00e0m \u0111\u1ebfm th\u00f4ng th\u01b0\u1eddng nh\u01b0 COUNT, COUNTA, COUNTIF \u0111\u1ec3 \u0111\u1ebfm nh\u1eefng \u00f4 d\u1ef1a theo m\u00e0u s\u1eafc \u0111\u01b0\u1ee3c. Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n 3 c\u00e1ch \u0111\u1ec3 c\u00f3 th\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-3-cach-dem-so-o-duoc-mau-trong-excel.html\"><strong>\u0111\u1ebfm s\u1ed1 \u00f4 \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u trong Excel<\/strong><\/a><\/em><\/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-6765d4b313d1a\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-dem-so-o-duoc-mau-trong-excel.html#Su_dung_ham_SUBTOTAL_va_cong_cu_loc_theo_mau\" title=\"S\u1eed d\u1ee5ng h\u00e0m SUBTOTAL v\u00e0 c\u00f4ng c\u1ee5 l\u1ecdc theo m\u00e0u\">S\u1eed d\u1ee5ng h\u00e0m SUBTOTAL v\u00e0 c\u00f4ng c\u1ee5 l\u1ecdc theo m\u00e0u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-dem-so-o-duoc-mau-trong-excel.html#Su_dung_ham_COUNTIF_ket_hop_voi_ham_GETCELL\" title=\"S\u1eed d\u1ee5ng h\u00e0m COUNTIF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m GET.CELL\">S\u1eed d\u1ee5ng h\u00e0m COUNTIF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m GET.CELL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-dem-so-o-duoc-mau-trong-excel.html#Su_dung_ham_tu_tao_trong_VBA\" title=\"S\u1eed d\u1ee5ng h\u00e0m t\u1ef1 t\u1ea1o trong VBA\">S\u1eed d\u1ee5ng h\u00e0m t\u1ef1 t\u1ea1o trong VBA<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-dem-so-o-duoc-mau-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_SUBTOTAL_va_cong_cu_loc_theo_mau\"><\/span>S\u1eed d\u1ee5ng h\u00e0m SUBTOTAL v\u00e0 c\u00f4ng c\u1ee5 l\u1ecdc theo m\u00e0u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch n\u00e0y d\u1ef1a tr\u00ean 2 nguy\u00ean t\u1eafc sau:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/ham-subtotal-cac-ung-dung-cua-subtotal-trong-excel.html\">H\u00e0m SUBTOTAL<\/a> l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t linh ho\u1ea1t trong\u00a0Excel. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng trong vi\u1ec7c t\u00ednh t\u1ed5ng,\u00a0\u0111\u1ebfm\u2026\u00a0\u0111\u1eb7c bi\u1ec7t h\u01a1n l\u00e0 n\u00f3 cho ph\u00e9p b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb\u00a0\u1ea9n\u00a0\u0111i khi l\u1ecdc b\u1eb1ng Filter ho\u1eb7c s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng\u00a0\u1ea9n d\u00f2ng (Hide).<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-loc-du-lieu-trong-excel.html\">C\u00f4ng c\u1ee5 l\u1ecdc (Filter) trong\u00a0Excel<\/a> c\u00f3 kh\u1ea3 n\u0103ng h\u1ed7 tr\u1ee3 b\u1ea1n l\u1ecdc theo c\u00e1c\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c t\u00f4 m\u00e0u.<\/li>\n<\/ul>\n<p>Khi k\u1ebft h\u1ee3p 2 t\u00ednh n\u0103ng n\u00e0y, ta s\u1ebd th\u1ea5y Khi l\u1ecdc theo m\u00e0u, k\u1ebft qu\u1ea3 s\u1ebd c\u00f2n l\u1ea1i nh\u1eefng\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c t\u00f4 m\u00e0u\u00a0theo\u00a0\u0111\u00fang m\u00e0u\u00a0\u0111\u01b0\u1ee3c l\u1ecdc. Nh\u1eefng\u00a0\u00f4 c\u00f3 m\u00e0u kh\u00e1c s\u1ebd\u00a0\u0111\u01b0\u1ee3c b\u1ecf qua. Khi\u00a0\u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm c\u00e1c\u00a0\u00f4 c\u00f2n l\u1ea1i\u00a0s\u1ebd cho b\u1ea1n k\u1ebft qu\u1ea3 nh\u01b0\u00a0\u00fd mu\u1ed1n.<\/p>\n<p>C\u00e1ch l\u00e0m c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c t\u00f4 m\u00e0u theo c\u00e1c n\u1ed9i dung nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31056 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/de-bai-dem-theo-mau.png\" alt=\"cach-dem-so-o-duoc-to-mau-trong-excel-1\" width=\"418\" height=\"406\" title=\"de-bai-dem-theo-mau\"><\/p>\n<p>V\u1edbi m\u1ed7i 1 chi nh\u00e1nh s\u1ebd\u00a0\u0111\u01b0\u1ee3c t\u00f4 theo 1 m\u00e0u ri\u00eang. Khi mu\u1ed1n\u00a0\u0111\u1ebfm theo m\u00e0u, ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n l\u1ea7n l\u01b0\u1ee3t 2 b\u01b0\u1edbc nh\u01b0 sau:<\/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-504.gif\" title=\"ex101_92019-nho-504\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1: D\u00f9ng h\u00e0m SUBTOTAL\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm.<\/strong><\/p>\n<p>S\u1eed d\u1ee5ng h\u00e0m SUBTOTAL t\u1ea1i v\u1ecb tr\u00ed \u00f4 C11:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31057 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-bang-ham-subtotal-102.png\" alt=\"cach-dem-so-o-duoc-to-mau-trong-excel-2\" width=\"587\" height=\"408\" title=\"dem-bang-ham-subtotal-102\"><\/p>\n<blockquote>\n<p>=SUBTOTAL(102, C2:C10)<\/p>\n<\/blockquote>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Tham s\u1ed1 102 l\u00e0 s\u1eed d\u1ee5ng cho h\u00e0m COUNT\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm<\/li>\n<li>V\u00f9ng\u00a0\u00f4 c\u1ea7n\u00a0\u0111\u1ebfm l\u00e0 v\u00f9ng C2:C10<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c = 9 l\u00e0 9\u00a0\u00f4.<\/p>\n<p><strong>B\u01b0\u1edbc 2: L\u1ecdc d\u1eef li\u1ec7u theo m\u00e0u v\u00e0 xem k\u1ebft qu\u1ea3<\/strong><\/p>\n<p>Ti\u1ebfp theo ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Filter (Auto Filter)\u00a0\u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u theo m\u00e0u s\u1eafc.<\/p>\n<ul>\n<li>Trong th\u1ebb Data ch\u1ecdn Filter\u00a0\u0111\u1ec3\u00a0\u00e1p d\u1ee5ng b\u1ed9 l\u1ecdc cho b\u1ea3ng<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31058 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ap-dung-bo-loc-auto-filter-1024x556-1.png\" alt=\"cach-dem-so-o-duoc-to-mau-trong-excel-3\" width=\"1024\" height=\"556\" title=\"ap-dung-bo-loc-auto-filter-1024x556-1\"><\/p>\n<ul>\n<li>Th\u1ef1c hi\u1ec7n l\u1ecdc theo m\u00e0u\u00a0v\u1edbi ch\u1ee9c n\u0103ng Filter by Color:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31059 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loc-theo-mau-filter-by-color.png\" alt=\"cach-dem-so-o-duoc-to-mau-trong-excel-4\" width=\"532\" height=\"565\" title=\"loc-theo-mau-filter-by-color\"><\/p>\n<ul>\n<li>K\u1ebft qu\u1ea3 sau khi l\u1ecdc theo m\u00e0u:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31060 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-filter-by-color.png\" alt=\"cach-dem-so-o-duoc-to-mau-trong-excel-6\" width=\"415\" height=\"205\" title=\"ket-qua-filter-by-color\"><\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y sau khi l\u1ecdc theo m\u00e0u t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi chi nh\u00e1nh H\u00e0 N\u1ed9i, k\u1ebft qu\u1ea3 c\u00f2n l\u1ea1i 3 d\u00f2ng n\u1ed9i dung, v\u00e0 h\u00e0m SUBTOTAL tr\u1ea3 v\u1ec1\u00a0\u0111\u00fang k\u1ebft qu\u1ea3 b\u1eb1ng 3.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3\u00a0\u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 b\u1ed9 l\u1ecdc cho m\u00e0u kh\u00e1c\u00a0\u0111\u1ec3 xem k\u1ebft qu\u1ea3 t\u1ef1 thay\u00a0\u0111\u1ed5i cho m\u00e0u\u00a0\u0111\u00f3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_COUNTIF_ket_hop_voi_ham_GETCELL\"><\/span>S\u1eed d\u1ee5ng h\u00e0m COUNTIF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m GET.CELL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m Get.Cell l\u00e0 1 h\u00e0m\u00a0\u1ea9n trong\u00a0Excel,\u00a0b\u00ecnh th\u01b0\u1eddng ch\u00fang ta kh\u00f4ng g\u1ecdi h\u00e0m n\u00e0y l\u00ean\u00a0\u0111\u01b0\u1ee3c. Tuy nhi\u00ean c\u00f3 1 c\u00e1ch\u00a0\u0111\u1ec3 s\u1eed d\u1ee5ng\u00a0\u0111\u00f3 l\u00e0 d\u00f9ng th\u00f4ng qua vi\u1ec7c \u0111\u1eb7t t\u00ean v\u00f9ng (Name Range).<\/p>\n<p>H\u00e0m Get.Cell\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh m\u00e0u trong\u00a0\u00f4:<\/p>\n<blockquote>\n<p>=Get.Cell(38, &lt;\u00f4 tham chi\u1ebfu&gt;)<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31056 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/de-bai-dem-theo-mau.png\" alt=\"cach-dem-so-o-duoc-to-mau-trong-excel-1\" width=\"418\" height=\"406\" title=\"de-bai-dem-theo-mau\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean,\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh xem c\u00e1c\u00a0\u00f4 trong c\u1ed9t C\u00a0\u0111\u01b0\u1ee3c t\u00f4 m\u00e0u g\u00ec, ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: Trong th\u1ebb Formulas, ch\u1ecdn Define Name, th\u1ef1c hi\u1ec7n thao t\u00e1c\u00a0\u0111\u1eb7t t\u00ean v\u00f9ng nh\u01b0 sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31064 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/get-cell-xac-dinh-ma-mau-dung-trong-o.png\" alt=\"cach-dem-so-o-duoc-to-mau-trong-excel-8\" width=\"377\" height=\"289\" title=\"get-cell-xac-dinh-ma-mau-dung-trong-o\"><\/p>\n<p>T\u00ean\u00a0\u0111\u01b0\u1ee3c s\u1eed\u00a0d\u1ee5ng: MaMauNen (M\u00e3 m\u00e0u n\u1ec1n \u2013 vi\u1ebft kh\u00f4ng d\u1ea5u)<\/p>\n<p>Trong th\u1ebb Refers to: vi\u1ebft h\u00e0m =GET.CELL(38, Sheet2!$C2)<\/p>\n<p style=\"padding-left: 30px\">+ 38 l\u00e0 tham s\u1ed1\u00a0x\u00e1c\u00a0\u0111\u1ecbnh m\u00e3 m\u00e0u n\u1ec1n trong\u00a0\u00f4<\/p>\n<p style=\"padding-left: 30px\">+ Sheet2!$C2 l\u00e0\u00a0\u00f4 C2 t\u1ea1i Sheet2 (\u00f4 b\u1eaft\u00a0\u0111\u1ea7u), trong\u00a0\u0111\u00f3 c\u1ed1\u00a0\u0111\u1ecbnh c\u1ed9t C, kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh d\u00f2ng 2 (\u0111\u1ec3 h\u00e0m c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng cho c\u00e1c d\u00f2ng kh\u00e1c trong c\u1ed9t C)<\/p>\n<ul>\n<li>B\u01b0\u1edbc 2: Sau khi\u00a0\u0111\u1eb7t t\u00ean, ch\u00fang ta s\u1ebd\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c t\u1ea1i c\u1ed9t D (c\u1ed9t ph\u1ee5 l\u00e0m c\u0103n c\u1ee9 x\u00e1c\u00a0\u0111\u1ecbnh k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Get.Cell)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31065 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-xac-dinh-ma-mau-nen.png\" alt=\"cach-dem-so-o-duoc-to-mau-trong-excel-9\" width=\"568\" height=\"342\" title=\"cong-thuc-xac-dinh-ma-mau-nen\"><\/p>\n<p>T\u1ea1i\u00a0\u00f4 D2 nh\u1eadp c\u00f4ng th\u1ee9c<\/p>\n<p style=\"padding-left: 30px\">=MaMauNen<\/p>\n<p>\u0110\u00e2y ch\u00ednh l\u00e0 t\u00ean\u00a0\u0111\u00e3\u00a0\u0111\u1eb7t\u00a0\u1edf b\u01b0\u1edbc 1. Filldown c\u00f4ng th\u1ee9c t\u1eeb\u00a0\u00f4 D2 t\u1edbi\u00a0\u00f4 D10, ta s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 m\u00e3 m\u00e0u n\u1ec1n\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c\u00a0\u00f4.<\/p>\n<p><span style=\"text-decoration: underline\"><strong>L\u01b0u\u00a0\u00fd:<\/strong><\/span><\/p>\n<ul>\n<li>H\u00e0m MaMauNen kh\u00f4ng d\u00f9ng tr\u1ef1c ti\u1ebfp\u00a0\u0111\u01b0\u1ee3c m\u00e0 ph\u1ea3i d\u00f9ng th\u00f4ng qua name range<\/li>\n<li>Tham chi\u1ebfu khi\u00a0\u0111\u1eb7t t\u00ean ch\u00ednh l\u00e0\u00a0\u00f4 s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 m\u00e3 m\u00e0u<\/li>\n<li>H\u00e0m ch\u1ec9 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c m\u00e0u n\u1ec1n\u00a0\u0111\u01b0\u1ee3c t\u00f4 tr\u1ef1c ti\u1ebfp v\u1edbi Fill Color, <strong>kh\u00f4ng x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c m\u00e0u do ch\u1ee9c n\u0103ng Conditional formatting t\u1ea1o ra<\/strong>.<\/li>\n<\/ul>\n<p>Cu\u1ed1i c\u00f9ng ch\u00fang ta mu\u1ed1n\u00a0\u0111\u1ebfm\u00f4 theo m\u00e0u n\u00e0o ch\u1ec9 c\u1ea7n d\u1ef1a tr\u00ean k\u1ebft qu\u1ea3 m\u00e3 m\u00e0u\u00a0\u0111\u00e3 c\u00f3\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm (\u0111\u1ebfm theo k\u1ebft qu\u1ea3 s\u1ed1 trong c\u1ed9t D v\u1edbi h\u00e0m COUNTIF,\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u00e3 m\u00e0u\u00a0\u0111\u00e3 c\u00f3)<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_tu_tao_trong_VBA\"><\/span>S\u1eed d\u1ee5ng h\u00e0m t\u1ef1 t\u1ea1o trong VBA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ed9i dung n\u00e0y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft t\u1ea1i b\u00e0i vi\u1ebft d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dem-va-tinh-tong-dua-theo-mau-sac-cua-o-tinh-bang-vba.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ebfm v\u00e0 t\u00ednh t\u1ed5ng d\u1ef1a theo m\u00e0u s\u1eafc c\u1ee7a \u00f4 t\u00ednh b\u1eb1ng VBA<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Qua b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y\u00a0m\u1ed9t v\u1ea5n\u00a0\u0111\u1ec1 t\u01b0\u1edfng kh\u00f3 th\u1ef1c hi\u1ec7n l\u1ea1i c\u00f3 th\u1ec3 l\u00e0m\u00a0\u0111\u01b0\u1ee3c v\u1edbi nhi\u1ec1u c\u00e1ch kh\u00e1c nhau. Th\u1eadt b\u1ea5t ng\u1edd ph\u1ea3i kh\u00f4ng n\u00e0o. Vi\u1ec7c th\u00e0nh th\u1ea1o Excel s\u1ebd gi\u00fap b\u1ea1n lu\u00f4n ch\u1ee7\u00a0\u0111\u1ed9ng trong m\u1ecdi t\u00ecnh hu\u1ed1ng, t\u0103ng kh\u1ea3 n\u0103ng gi\u1ea3i quy\u1ebft nh\u1eefng c\u00f4ng vi\u1ec7c kh\u00f3 v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c.<\/p>\n<p>Nh\u1eb1m gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7n th\u1eddi gian, c\u00f4ng s\u1ee9c v\u00e0 chi ph\u00ed cho vi\u1ec7c h\u1ecdc\u00a0Excel, ch\u00fang t\u00f4i xin gi\u1edbi thi\u1ec7u v\u1edbi b\u1ea1n kh\u00f3a h\u1ecdc\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\/excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/a><\/strong>.\u00a0Gi\u1ea3ng vi\u00ean c\u1ee7a kh\u00f3a h\u1ecdc n\u00e0y l\u00e0 th\u1ea7y Nguy\u1ec5n\u00a0\u0110\u1ee9c Thanh \u2013 gi\u1ea3ng vi\u00ean v\u1ec1 tin h\u1ecdc v\u0103n ph\u00f2ng uy t\u00edn nh\u1ea5t t\u1ea1i Vi\u1ec7t Nam. V\u1edbi n\u1ed9i dung chi ti\u1ebft,\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7, d\u1ec5 hi\u1ec3u, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 y\u00ean t\u00e2m v\u1ec1 ki\u1ebfn th\u1ee9c s\u1ebd c\u00f3\u00a0\u0111\u01b0\u1ee3c khi tham gia h\u1ecdc kh\u00f3a h\u1ecdc n\u00e0y. Ngo\u00e0i ra b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 h\u1ecdc c\u00f9ng v\u1edbi h\u00e0ng ngh\u00ecn h\u1ecdc vi\u00ean kh\u00e1c trong kh\u00f3a h\u1ecdc n\u00e0y, tham kh\u1ea3o nh\u1eefng v\u00ed d\u1ee5 th\u1ef1c t\u1ebf th\u00f4ng qua vi\u1ec7c th\u1ea3o lu\u1eadn c\u00f9ng gi\u1ea3ng vi\u00ean. Nh\u1eefng\u00a0\u0111i\u1ec1u n\u00e0y r\u1ea5t b\u1ed5\u00a0\u00edch, gi\u00fap b\u1ea1n v\u1eeba h\u1ecdc, v\u1eeba v\u1eadn d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c ki\u1ebfn th\u1ee9c v\u00e0o trong c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf.<\/p>\n<p>H\u00e3y nhanh tay\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\/excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">\u0111\u0103ng k\u00fd<\/a>\u00a0\u0111\u1ec3 nh\u1eadn\u00a0\u0111\u01b0\u1ee3c\u00a0\u01b0u\u00a0\u0111\u00e3i t\u1eeb\u00a0<strong>H\u1ecdc\u00a0Excel Online<\/strong>\u00a0ngay nh\u00e9!<\/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-504.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5751,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5750","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\/5750","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=5750"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5750\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5751"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}