{"id":3012,"date":"2024-12-02T09:50:46","date_gmt":"2024-12-02T09:50:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-loc-va-sap-xep-lai-cac-dong-bang-mau-nen-mau-chu-va-bieu-tuong-trong-excel\/"},"modified":"2024-12-02T09:50:46","modified_gmt":"2024-12-02T09:50:46","slug":"cach-loc-va-sap-xep-lai-cac-dong-bang-mau-nen-mau-chu-va-bieu-tuong-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-loc-va-sap-xep-lai-cac-dong-bang-mau-nen-mau-chu-va-bieu-tuong-trong-excel\/","title":{"rendered":"C\u00e1ch l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp l\u1ea1i c\u00e1c d\u00f2ng b\u1eb1ng m\u00e0u n\u1ec1n, m\u00e0u ch\u1eef v\u00e0 bi\u1ec3u t\u01b0\u1ee3ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\">Blog H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1eb9o s\u1eafp x\u1ebfp \u00f4 t\u00ednh b\u1eb1ng m\u00e0u n\u1ec1n \u00f4 ho\u1eb7c m\u00e0u ch\u1eef trong Excel 2016 t\u1edbi 2010.<\/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-674d82f5c37b9\" 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\/cach-loc-va-sap-xep-lai-cac-dong-bang-mau-nen-mau-chu-va-bieu-tuong-trong-excel.html#Sap_xep_lai_cac_dong_bang_mau_o_tinh\" title=\"S\u1eafp x\u1ebfp l\u1ea1i c\u00e1c d\u00f2ng b\u1eb1ng m\u00e0u \u00f4 t\u00ednh\">S\u1eafp x\u1ebfp l\u1ea1i c\u00e1c d\u00f2ng b\u1eb1ng m\u00e0u \u00f4 t\u00ednh<\/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\/cach-loc-va-sap-xep-lai-cac-dong-bang-mau-nen-mau-chu-va-bieu-tuong-trong-excel.html#Sap_xep_cac_dong_cua_bang_tinh_theo_mau_chu_trong_Excel\" title=\"S\u1eafp x\u1ebfp c\u00e1c d\u00f2ng c\u1ee7a b\u1ea3ng t\u00ednh theo m\u00e0u ch\u1eef trong Excel:\">S\u1eafp x\u1ebfp c\u00e1c d\u00f2ng c\u1ee7a b\u1ea3ng t\u00ednh theo m\u00e0u ch\u1eef trong Excel:<\/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\/cach-loc-va-sap-xep-lai-cac-dong-bang-mau-nen-mau-chu-va-bieu-tuong-trong-excel.html#Sap_xep_cac_dong_trong_bang_tinh_theo_bieu_tuong_trong_Excel\" title=\"S\u1eafp x\u1ebfp c\u00e1c d\u00f2ng trong b\u1ea3ng t\u00ednh theo bi\u1ec3u t\u01b0\u1ee3ng trong Excel:\">S\u1eafp x\u1ebfp c\u00e1c d\u00f2ng trong b\u1ea3ng t\u00ednh theo bi\u1ec3u t\u01b0\u1ee3ng trong Excel:<\/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\/cach-loc-va-sap-xep-lai-cac-dong-bang-mau-nen-mau-chu-va-bieu-tuong-trong-excel.html#Cach_loc_o_tinh_theo_mau_trong_Excel\" title=\"C\u00e1ch l\u1ecdc \u00f4 t\u00ednh theo m\u00e0u trong Excel:\">C\u00e1ch l\u1ecdc \u00f4 t\u00ednh theo m\u00e0u trong Excel:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Sap_xep_lai_cac_dong_bang_mau_o_tinh\"><\/span><strong>S\u1eafp x\u1ebfp l\u1ea1i c\u00e1c d\u00f2ng b\u1eb1ng m\u00e0u \u00f4 t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">S\u1eafp x\u1ebfp \u00f4 t\u00ednh b\u1eb1ng m\u00e0u l\u00e0 nhi\u1ec7m v\u1ee5 d\u1ec5 nh\u1ea5t trong Excel, so v\u1edbi vi\u1ec7c \u0111\u1ebfm, t\u00ednh t\u1ed5ng, th\u1eadm ch\u00ed l\u1ecdc. Kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng m\u00e3 <strong>VBA <\/strong>hay c\u00f4ng th\u1ee9c. Ch\u00fang ta ch\u1ec9 \u0111\u01a1n gi\u1ea3n s\u1eed d\u1ee5ng <strong><em>Custom Sort <\/em><\/strong>c\u00f3 s\u1eb5n trong c\u00e1c phi\u00ean b\u1ea3n Excel 2013, 2010, 2007.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n<li>V\u00e0o th\u1ebb <strong><em>Home &gt; Editing<\/em><\/strong>, nh\u1ea5p ch\u1ecdn <strong><em>Sort &amp; Filter<\/em><\/strong>, ch\u1ecdn <strong><em>Custom Sort\u2026<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-sort.png\" alt=\"Click the Sort &amp; Filter button and select Custom Sort&hellip;\" title=\"custom-sort\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Trong h\u1ed9p tho\u1ea1i <strong><em>Sort<\/em><\/strong>, \u0111\u1eb7t c\u00e1c ch\u1ec9 ti\u00eau theo th\u1ee9 t\u1ef1 t\u1eeb tr\u00e1i sang ph\u1ea3i.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">C\u1ed9t c\u1ea7n s\u1eafp x\u1ebfp (V\u00ed d\u1ee5: c\u1ed9t \u201cDelivery\u201d)<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn <strong><em>Cell Color <\/em><\/strong>trong <strong><em>Sort On<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn m\u00e0u \u00f4 t\u00ednh b\u1ea1n mu\u1ed1n \u0111\u1ec3 tr\u00ean c\u00f9ng trong <strong><em>Order<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn <strong><em>On Top<\/em><\/strong><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-95.gif\" title=\"vba101_92019-nho-95\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-228.gif\" title=\"ex101_92019-nho-228\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sort-by-color.png\" alt=\"Sort cells by colour using Excel's Custom Sort feature.\" title=\"sort-by-color\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5n v\u00e0o n\u00fat <strong><em>Copy Level <\/em><\/strong>\u0111\u1ec3 th\u00eam nhi\u1ec1u ti\u00eau ch\u00ed s\u1eafp x\u1ebfp kh\u00e1c t\u01b0\u01a1ng t\u1ef1 c\u00e1i \u0111\u1ea7u ti\u00ean. Sau \u0111\u00f3, d\u01b0\u1edbi \u00f4 <strong><em>Order<\/em><\/strong>, ch\u1ecdn m\u00e0u th\u1ee9 hai trong th\u1ee9 t\u1ef1 \u01b0u ti\u00ean. Th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 trong c\u00e1c \u00f4 ti\u1ebfp theo \u0111\u1ed1i v\u1edbi c\u00e1c m\u00e0u kh\u00e1c nhau trong b\u1ea3ng c\u1ee7a b\u1ea1n.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-level.png\" title=\"copy-level\"><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>Nh\u1ea5n OK v\u00e0 x\u00e1c nh\u1eadn c\u00e1c h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo m\u00e0u \u0111\u00fang ch\u01b0a.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Trong b\u1ea3ng c\u1ee7a ch\u00fang ta, th\u1ee9 t\u1ef1 c\u1ee7a \u201cPast Due\u201d n\u1eb1m tr\u00ean c\u00f9ng, sau \u0111\u00f3 \u0111\u1ebfn c\u00e1c h\u00e0ng \u201cDue in\u201d, v\u00e0 cu\u1ed1i c\u00f9ng \u0111\u1ebfn c\u00e1c h\u00e0ng \u201cDelivered\u201d, theo \u0111\u00fang nh\u1eefng g\u00ec ch\u00fang ta mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/rows-sorted-by-color.png\" alt=\"Row sorted by color\" title=\"rows-sorted-by-color\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu c\u00e1c \u00f4 t\u00ednh \u0111\u01b0\u1ee3c t\u00f4 nhi\u1ec1u m\u00e0u kh\u00e1c nhau, kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng cho t\u1eebng \u00f4 ho\u1eb7c t\u1ea5t c\u1ea3 c\u00e1c \u00f4. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh d\u1ea1ng cho nh\u1eefng m\u00e0u \u00f4 quan tr\u1ecdng, v\u00ed d\u1ee5 nh\u01b0 \u201cPast due\u201d trong v\u00ed d\u1ee5 v\u00e0 \u0111\u1ec3 nguy\u00ean c\u00e1c h\u00e0ng kh\u00e1c \u1edf th\u1ee9 t\u1ef1 hi\u1ec7n t\u1ea1i.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sort-by-color.png\" alt=\"Sort cells by colour using Excel's Custom Sort feature.\" title=\"sort-by-color\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp c\u00e1c \u00f4 t\u00ednh theo m\u1ed9t m\u00e0u, c\u00f2n m\u1ed9t c\u00e1ch nhanh h\u01a1n. Ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o m\u0169i t\u00ean <strong><em>AutoFilter <\/em><\/strong>b\u00ean c\u1ea1nh ti\u00eau \u0111\u1ec1 c\u1ed9t b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp, ch\u1ecdn <strong><em>Sort by Color <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn, sau \u0111\u00f3 h\u1ecdn m\u00e0u cho \u00f4 t\u00ednh b\u1ea1n mu\u1ed1n \u0111\u1eb7t tr\u00ean c\u00f9ng hay d\u01b0\u1edbi c\u00f9ng. D\u00f9 th\u1ebf n\u00e0y, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Custom Sort<\/em><\/strong>, nh\u01b0 b\u1ea1n th\u1ea5y trong ph\u1ea7n b\u00ean ph\u1ea3i h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sort-by-one-color.png\" alt=\"Sort cells by one color using Excel's AutoFilter.\" title=\"sort-by-one-color\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">\u0110\u0103ng ky\u0301 ngay: Kh\u00f3a h\u1ecdc excel n\u00e2ng cao H\u00e0 N\u1ed9i<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Sap_xep_cac_dong_cua_bang_tinh_theo_mau_chu_trong_Excel\"><\/span><strong>S\u1eafp x\u1ebfp c\u00e1c d\u00f2ng c\u1ee7a b\u1ea3ng t\u00ednh theo m\u00e0u ch\u1eef trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Th\u1eadt ra, s\u1eafp x\u1ebfp c\u00e1c \u00f4 t\u00ednh theo m\u00e0u ch\u1eef c\u0169ng t\u01b0\u01a1ng t\u1ef1 c\u00e1ch s\u1eafp x\u1ebfp theo m\u00e0u m\u1ec1n \u00f4. B\u1ea1n c\u0169ng s\u1eed d\u1ee5ng <strong><em>Custom Sort <\/em><\/strong>(<strong><em>Home &gt; Sort &amp; Filter &gt; Custom Sort\u2026<\/em><\/strong>), nh\u01b0ng l\u1ea7n n\u00e0y b\u1ea1n h\u00e3y ch\u1ecdn <strong><em>Font Color <\/em><\/strong>trong d\u01b0\u1edbi ph\u1ea7n <strong><em>Sort on<\/em><\/strong> nh\u01b0 trong h\u00ecnh ch\u1ee5p d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5877\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-88.png\" width=\"600\" height=\"396\" title=\"excel-dialog-box-launcher-1-88\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp ch\u1ec9 theo m\u1ed9t m\u00e0u ch\u1eef, h\u00e3y s\u1eed d\u1ee5ng <strong><em>AutoFilter:<\/em><\/strong><strong><em><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5878\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-89.png\" width=\"600\" height=\"158\" title=\"excel-dialog-box-launcher-1-89\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u01b0\u0300ng bo\u0309 l\u01a1\u0303:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">H\u01b0\u1edbng d\u1eabn h\u1ecdc excel c\u01a1 b\u1ea3n<\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Sap_xep_cac_dong_trong_bang_tinh_theo_bieu_tuong_trong_Excel\"><\/span><strong>S\u1eafp x\u1ebfp c\u00e1c d\u00f2ng trong b\u1ea3ng t\u00ednh theo bi\u1ec3u t\u01b0\u1ee3ng trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean con s\u1ed1 trong c\u1ed9t \u201cQty\u201d nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/source-data-icon-sets.png\" alt=\"Original data formatted with the conditional formatting icon set\" title=\"source-data-icon-sets\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, nh\u1eefng \u0111\u01a1n h\u00e0ng l\u1edbn v\u1edbi s\u1ed1 l\u01b0\u1ee3ng l\u1edbn h\u01a1n 6 \u0111\u01b0\u1ee3c \u0111\u1eb7t bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ecf, \u0111\u01a1n h\u00e0ng v\u1eeba c\u00f3 bi\u1ec3u t\u01b0\u1ee3ng v\u00e0ng v\u00e0 \u0111\u01a1n h\u00e0ng nh\u1ecf \u0111\u01b0\u1ee3c g\u1eafn v\u1edbi bi\u1ec3u t\u01b0\u1ee3ng xanh l\u00e1 c\u00e2y. N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u01a1n h\u00e0ng quan tr\u1ecdng nh\u1ea5t \u0111\u1eb7t \u1edf tr\u00ean c\u00f9ng, s\u1eed d\u1ee5ng <strong><em>Custom Sort <\/em><\/strong>t\u01b0\u01a1ng t\u1ef1 nh\u1eefng h\u01b0\u1edbng d\u1eabn tr\u00ean v\u00e0 ch\u1ecdn s\u1eafp x\u1ebfp theo <strong><em>Cell Icon<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sort-by-cell-icon.png\" alt=\"Sorting by cell icon\" title=\"sort-by-cell-icon\"><\/p>\n<p style=\"text-align: justify\">Ch\u1ec9 c\u1ea7n x\u00e1c \u0111\u1ecbnh th\u1ee9 t\u1ef1 c\u1ee7a hai trong s\u1ed1 ba bi\u1ec3u t\u01b0\u1ee3ng, t\u1ea5t c\u1ea3 c\u00e1c \u0111\u01a1n h\u00e0ng \u0111\u01b0\u1ee3c g\u1eafn bi\u1ec3u t\u01b0\u1ee3ng m\u00e0u xanh l\u00e1 s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n t\u1edbi cu\u1ed1i b\u1ea3ng.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sorted-by-cell-icon.png\" alt=\"Excel data sorted by cell icon\" title=\"sorted-by-cell-icon\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_loc_o_tinh_theo_mau_trong_Excel\"><\/span><strong>C\u00e1ch l\u1ecdc \u00f4 t\u00ednh theo m\u00e0u trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n l\u1ecdc c\u00e1c h\u00e0ng trong m\u1ed9t c\u1ed9t c\u1ee5 th\u1ec3 theo m\u00e0u, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong><em>Filter by Color <\/em><\/strong>trong Excel 2010 v\u00e0 2013.<\/p>\n<p style=\"text-align: justify\">Gi\u1edbi h\u1ea1n c\u1ee7a t\u00ednh n\u0103ng n\u00e0y l\u00e0 ch\u1ec9 cho l\u1ecdc theo m\u1ed9t m\u00e0u m\u1ed9t l\u1ea7n. N\u1ebfu b\u1ea1n mu\u1ed1n l\u1ecdc s\u1eef li\u1ec7u theo nhi\u1ec1u h\u01a1n hai m\u00e0u, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y:<\/p>\n<ol style=\"text-align: justify\">\n<li>Th\u00eam c\u1ed9t ph\u1ee5 v\u00e0o cu\u1ed1i b\u1ea3ng d\u1eef li\u1ec7u ho\u1eb7c k\u1ebf b\u00ean c\u1ed9t b\u1ea1n mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u, \u0111\u1eb7t t\u00ean n\u00f3 l\u00e0 \u201cFilter by color\u201d.<\/li>\n<li>Nh\u1eadp c\u00f4ng th\u1ee9c <strong><em>=GetCellColor(F2)<\/em><\/strong> v\u00e0o \u00f4 t\u00ednh th\u1ee9 2 trong c\u1ed9t m\u1edbi th\u00eam, trong \u0111\u00f3 F l\u00e0 c\u1ed9t s\u1eafp x\u1ebfp c\u00e1c \u00f4 m\u00e0u b\u1ea1n mu\u1ed1n l\u1ecdc.<\/li>\n<li>Sao ch\u00e9p c\u00f4ng th\u1ee9c sang to\u00e0n b\u1ed9 c\u1ed9t \u201cFilter by color\u201d<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/filter-by-color-column.png\" alt=\"Add the formula to get the color code.\" title=\"filter-by-color-column\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>S\u1eed d\u1ee5ng <strong><em>AutoFilter <\/em><\/strong>nh\u01b0 b\u00ecnh th\u01b0\u1eddng v\u00e0 sau \u0111\u00f3 ch\u1ecdn m\u00e0u b\u1ea1n c\u1ea7n trong danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-color-codes.png\" alt=\"Select the needed colors from the drop-down list.\" title=\"select-color-codes\"><\/p>\n<p style=\"text-align: justify\">Cu\u1ed1i c\u00f9ng, b\u1ea1n s\u1ebd c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u ch\u1ec9 hi\u1ec3n th\u1ecb c\u00e1c h\u00e0ng c\u00f3 hai m\u00e0u nh\u01b0 b\u1ea1n \u0111\u00e3 ch\u1ecdn trong c\u1ed9t \u201cFilter by color\u201d.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cells-filtered-by-colors.png\" alt=\"Rows filtered by several colors in Excel 2010.\" title=\"cells-filtered-by-colors\"><\/p>\n<p style=\"text-align: justify\">Ngu\u1ed3n: Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi blog.hocexcel.online<\/p>\n<p>\u2013 \u2013 \u2013 \u2013 \u2013<\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel.<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2o9P7hq\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-95.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3013,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3012","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3012","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=3012"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3012\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3013"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3012"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3012"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3012"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}