{"id":3524,"date":"2024-12-03T02:48:15","date_gmt":"2024-12-03T02:48:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-dem-va-tinh-tong-dua-theo-mau-sac-cua-o-tinh-bang-vba\/"},"modified":"2024-12-03T02:48:15","modified_gmt":"2024-12-03T02:48:15","slug":"huong-dan-cach-dem-va-tinh-tong-dua-theo-mau-sac-cua-o-tinh-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-dem-va-tinh-tong-dua-theo-mau-sac-cua-o-tinh-bang-vba\/","title":{"rendered":"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"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd \u0111\u1ebfm c\u00e1c \u00f4 t\u00ednh b\u1eb1ng m\u00e0u s\u1eafc v\u00e0 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u. Nh\u1eefng gi\u1ea3i ph\u00e1p n\u00e0y hi\u1ec7u qu\u1ea3 \u0111\u1ed1i v\u1edbi c\u1ea3 \u00f4 t\u00ednh t\u00f4 m\u00e0u th\u1ee7 c\u00f4ng v\u00e0 \u00f4 t\u00ednh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n. \u0110\u1ed3ng th\u1eddi, b\u1ea1n c\u0169ng bi\u1ebft c\u00e1ch l\u1ecdc c\u00e1c \u00f4 t\u00ednh b\u1eb1ng nhi\u1ec1u m\u00e0u trong Excel 2010, 2013, 2016.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam b\u00e0i vi\u1ebft: <a href=\"http:\/\/blog.ezworkapp.com\/cach-loc-va-sap-xep-lai-cac-dong-bang-mau-nen-mau-chu-va-bieu-tuong-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">S\u1eafp x\u1ebfp c\u00e1c d\u00f2ng theo m\u00e0u<\/a><\/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-674e716eed827\" 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-cach-dem-va-tinh-tong-dua-theo-mau-sac-cua-o-tinh-bang-vba.html#Cach_dem_va_tinh_tong_bang_mau_trong_trang_tinh_Excel\" title=\"C\u00e1ch \u0111\u1ebfm v\u00e0 t\u00ednh t\u1ed5ng b\u1eb1ng m\u00e0u trong trang t\u00ednh Excel\">C\u00e1ch \u0111\u1ebfm v\u00e0 t\u00ednh t\u1ed5ng b\u1eb1ng m\u00e0u trong trang t\u00ednh Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dem-va-tinh-tong-dua-theo-mau-sac-cua-o-tinh-bang-vba.html#Tinh_tong_va_dem_so_o_bang_mau_sac_tren_toan_bo_bang_tinh\" title=\"T\u00ednh t\u1ed5ng v\u00e0 \u0111\u1ebfm s\u1ed1 \u00f4 b\u1eb1ng m\u00e0u s\u1eafc tr\u00ean to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh:\">T\u00ednh t\u1ed5ng v\u00e0 \u0111\u1ebfm s\u1ed1 \u00f4 b\u1eb1ng m\u00e0u s\u1eafc tr\u00ean to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dem-va-tinh-tong-dua-theo-mau-sac-cua-o-tinh-bang-vba.html#Chuc_nang_dem_theo_mau_sac\" title=\"Ch\u1ee9c n\u0103ng \u0111\u1ebfm theo m\u00e0u s\u1eafc:\">Ch\u1ee9c n\u0103ng \u0111\u1ebfm theo m\u00e0u s\u1eafc:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dem-va-tinh-tong-dua-theo-mau-sac-cua-o-tinh-bang-vba.html#Cach_dem_va_tinh_tong_cac_o_mau_dinh_dang_co_dieu_kien\" title=\"C\u00e1ch \u0111\u1ebfm v\u00e0 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 m\u00e0u \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n:\">C\u00e1ch \u0111\u1ebfm v\u00e0 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 m\u00e0u \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dem-va-tinh-tong-dua-theo-mau-sac-cua-o-tinh-bang-vba.html#Cach_su_dung_ma_de_dem_so_o_mau_va_tinh_tong_gia_tri_cua_chung\" title=\"C\u00e1ch s\u1eed d\u1ee5ng m\u00e3 \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 m\u00e0u v\u00e0 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang\">C\u00e1ch s\u1eed d\u1ee5ng m\u00e3 \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 m\u00e0u v\u00e0 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dem_va_tinh_tong_bang_mau_trong_trang_tinh_Excel\"><\/span><strong>C\u00e1ch \u0111\u1ebfm v\u00e0 t\u00ednh t\u1ed5ng b\u1eb1ng m\u00e0u trong trang t\u00ednh Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng li\u1ec7t k\u00ea danh s\u00e1ch \u0111\u01a1n \u0111\u1eb7c h\u00e0ng c\u1ee7a c\u00f4ng ty, trong \u0111\u00f3 c\u1ed9t Delivery \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang: \u201cDue in X Days\u201d \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u cam, \u201cDelivered\u201d \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u xanh l\u00e1 v\u00e0 \u201cPast Due\u201d \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u \u0111\u1ecf.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/colored-cells.png\" alt=\"The original table with cells colored based on value.\" title=\"colored-cells\"><\/p>\n<p style=\"text-align: justify\">Nh\u1eefng g\u00ec ch\u00fang ta mu\u1ed1n l\u00e0 t\u1ef1 \u0111\u1ed9ng t\u00ednh c\u00e1c \u00f4 theo m\u00e0u s\u1eafc, t\u1ee9c l\u00e0 t\u00ednh s\u1ed1 \u00f4 m\u00e0u \u0111\u1ecf, xanh l\u00e1 c\u00e2y v\u00e0 cam trong b\u1ea3ng t\u00ednh. H\u00e3y ti\u1ebfp t\u1ee5c v\u1edbi 5 b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y v\u00e0 b\u1ea1n s\u1ebd bi\u1ebft s\u1ed1 \u00f4 m\u1ed7i m\u00e0u v\u00e0 t\u1ed5ng c\u1ee7a ch\u00fang.<\/p>\n<ol style=\"text-align: justify\">\n<li>M\u1edf b\u1ea3ng t\u00ednh Excel v\u00e0 nh\u1ea5n <strong><em>Alt + F11<\/em><\/strong> \u0111\u1ec3 m\u1edf <strong><em>Visual Basic Editor<\/em><\/strong> (VBE).<\/li>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean b\u1ea3ng t\u00ednh d\u01b0\u1edbi <strong><em>Project-VBAProject<\/em><\/strong> \u1edf ph\u00eda tay ph\u1ea3i c\u1ee7a m\u00e0n h\u00ecnh, sau \u0111\u00f3 ch\u1ecdn <strong><em>Insert &gt; Module<\/em><\/strong> t\u1eeb 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\/insert-vba-module-1.png\" alt=\"Click Insert &gt; Module to add a new user-defined function to your worksheet.\" title=\"insert-vba-module-1\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Th\u00eam \u0111o\u1ea1n m\u00e3 sau v\u00e0o b\u1ea3ng t\u00ednh.<\/li>\n<\/ol>\n<table width=\"620\">\n<tbody>\n<tr>\n<td width=\"620\">Function GetCellColor(xlRange As Range)<\/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-117.gif\" title=\"vba101_92019-nho-117\"><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-272.gif\" title=\"ex101_92019-nho-272\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Dim indRow, indColumn As Long<\/p>\n<p>Dim arResults()<\/p>\n<p>\u00a0<\/p>\n<p>Application.Volatile<\/p>\n<p>\u00a0<\/p>\n<p>If xlRange Is Nothing Then<\/p>\n<p>Set xlRange = Application.ThisCell<\/p>\n<p>End If<\/p>\n<p>\u00a0<\/p>\n<p>If xlRange.Count &gt; 1 Then<\/p>\n<p>ReDim arResults(1 To xlRange.Rows.Count, 1 To xlRange.Columns.Count)<\/p>\n<p>For indRow = 1 To xlRange.Rows.Count<\/p>\n<p>For indColumn = 1 To xlRange.Columns.Count<\/p>\n<p>arResults(indRow, indColumn) = xlRange(indRow, indColumn).Interior.Color<\/p>\n<p>Next<\/p>\n<p>Next<\/p>\n<p>GetCellColor = arResults<\/p>\n<p>Else<\/p>\n<p>GetCellColor = xlRange.Interior.Color<\/p>\n<p>End If<\/p>\n<p>End Function<\/p>\n<p>\u00a0<\/p>\n<p>Function GetCellFontColor(xlRange As Range)<\/p>\n<p>Dim indRow, indColumn As Long<\/p>\n<p>Dim arResults()<\/p>\n<p>\u00a0<\/p>\n<p>Application.Volatile<\/p>\n<p>\u00a0<\/p>\n<p>If xlRange Is Nothing Then<\/p>\n<p>Set xlRange = Application.ThisCell<\/p>\n<p>End If<\/p>\n<p>\u00a0<\/p>\n<p>If xlRange.Count &gt; 1 Then<\/p>\n<p>ReDim arResults(1 To xlRange.Rows.Count, 1 To xlRange.Columns.Count)<\/p>\n<p>For indRow = 1 To xlRange.Rows.Count<\/p>\n<p>For indColumn = 1 To xlRange.Columns.Count<\/p>\n<p>arResults(indRow, indColumn) = xlRange(indRow, indColumn).Font.Color<\/p>\n<p>Next<\/p>\n<p>Next<\/p>\n<p>GetCellFontColor = arResults<\/p>\n<p>Else<\/p>\n<p>GetCellFontColor = xlRange.Font.Color<\/p>\n<p>End If<\/p>\n<p>\u00a0<\/p>\n<p>End Function<\/p>\n<p>\u00a0<\/p>\n<p>Function CountCellsByColor(rData As Range, cellRefColor As Range) As Long<\/p>\n<p>Dim indRefColor As Long<\/p>\n<p>Dim cellCurrent As Range<\/p>\n<p>Dim cntRes As Long<\/p>\n<p>\u00a0<\/p>\n<p>Application.Volatile<\/p>\n<p>cntRes = 0<\/p>\n<p>indRefColor = cellRefColor.Cells(1, 1).Interior.Color<\/p>\n<p>For Each cellCurrent In rData<\/p>\n<p>If indRefColor = cellCurrent.Interior.Color Then<\/p>\n<p>cntRes = cntRes + 1<\/p>\n<p>End If<\/p>\n<p>Next cellCurrent<\/p>\n<p>\u00a0<\/p>\n<p>CountCellsByColor = cntRes<\/p>\n<p>End Function<\/p>\n<p>\u00a0<\/p>\n<p>Function SumCellsByColor(rData As Range, cellRefColor As Range)<\/p>\n<p>Dim indRefColor As Long<\/p>\n<p>Dim cellCurrent As Range<\/p>\n<p>Dim sumRes<\/p>\n<p>\u00a0<\/p>\n<p>Application.Volatile<\/p>\n<p>sumRes = 0<\/p>\n<p>indRefColor = cellRefColor.Cells(1, 1).Interior.Color<\/p>\n<p>For Each cellCurrent In rData<\/p>\n<p>If indRefColor = cellCurrent.Interior.Color Then<\/p>\n<p>sumRes = WorksheetFunction.Sum(cellCurrent, sumRes)<\/p>\n<p>End If<\/p>\n<p>Next cellCurrent<\/p>\n<p>\u00a0<\/p>\n<p>SumCellsByColor = sumRes<\/p>\n<p>End Function<\/p>\n<p>\u00a0<\/p>\n<p>Function CountCellsByFontColor(rData As Range, cellRefColor As Range) As Long<\/p>\n<p>Dim indRefColor As Long<\/p>\n<p>Dim cellCurrent As Range<\/p>\n<p>Dim cntRes As Long<\/p>\n<p>\u00a0<\/p>\n<p>Application.Volatile<\/p>\n<p>cntRes = 0<\/p>\n<p>indRefColor = cellRefColor.Cells(1, 1).Font.Color<\/p>\n<p>For Each cellCurrent In rData<\/p>\n<p>If indRefColor = cellCurrent.Font.Color Then<\/p>\n<p>cntRes = cntRes + 1<\/p>\n<p>End If<\/p>\n<p>Next cellCurrent<\/p>\n<p>\u00a0<\/p>\n<p>CountCellsByFontColor = cntRes<\/p>\n<p>End Function<\/p>\n<p>\u00a0<\/p>\n<p>Function SumCellsByFontColor(rData As Range, cellRefColor As Range)<\/p>\n<p>Dim indRefColor As Long<\/p>\n<p>Dim cellCurrent As Range<\/p>\n<p>Dim sumRes<\/p>\n<p>\u00a0<\/p>\n<p>Application.Volatile<\/p>\n<p>sumRes = 0<\/p>\n<p>indRefColor = cellRefColor.Cells(1, 1).Font.Color<\/p>\n<p>For Each cellCurrent In rData<\/p>\n<p>If indRefColor = cellCurrent.Font.Color Then<\/p>\n<p>sumRes = WorksheetFunction.Sum(cellCurrent, sumRes)<\/p>\n<p>End If<\/p>\n<p>Next cellCurrent<\/p>\n<p>\u00a0<\/p>\n<p>SumCellsByFontColor = sumRes<\/p>\n<p>End Function<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>L\u01b0u b\u1ea3ng t\u00ednh th\u00e0nh \u201cExcel Macro-Enabled Workbook (.xlsm)\u201d.<\/li>\n<li>Nh\u01b0 v\u1eady, t\u1ea5t c\u1ea3 nh\u1eefng thao t\u00e1c l\u1eb7t v\u1eb7t \u0111\u00e3 th\u1ef1c hi\u1ec7n xong, ch\u1ec9 c\u1ea7n th\u00eam h\u00e0m \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, ch\u1ecdn \u00f4 t\u00ednh mu\u1ed1n hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c v\u00e0 g\u00f5 c\u00f4ng th\u1ee9c <strong><em>CountCellsByColor<\/em><\/strong><em>.<\/em><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><em>=CountCellsByColor(range, color code)<\/em><\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem ngay:\u00a0 <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">T\u00e0i li\u1ec7u Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong><em>= CountCellsByColor (F2:F14, A17)<\/em><\/strong> trong \u0111\u00f3 F2: F14 l\u00e0 d\u00e3y ch\u1ee9a c\u00e1c \u00f4 c\u00f3 m\u00e0u b\u1ea1n mu\u1ed1n \u0111\u1ebfm v\u00e0 A17 l\u00e0 \u00f4 c\u00f3 m\u00e0u n\u1ec1n nh\u1ea5t \u0111\u1ecbnh, trong v\u00ed d\u1ee5 \u0111\u00f3 l\u00e0 c\u00e1c \u00f4 m\u00e0u \u0111\u1ecf.<\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n vi\u1ebft c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 m\u00e0u kh\u00e1c, nh\u01b0 m\u00e0u v\u00e0ng v\u00e0 m\u00e0u xanh l\u00e1 c\u00e2y trong b\u1ea3ng c\u1ee7a ch\u00fang t\u00f4i.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-cells-by-color.png\" alt=\"The formula to count cells by background color\" title=\"count-cells-by-color\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u00f3 d\u1eef li\u1ec7u s\u1ed1 trong \u00f4 m\u00e0u, nh\u01b0 c\u1ed9t Qty, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam gi\u00e1 tr\u1ecb d\u1ef1a v\u00e0o m\u00e0u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m <strong><em>SumCellsByColor<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>=SumCellsByColor(range, color code)<\/em><\/strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sum-cells-by-color.png\" alt=\"The formula to sum cells by background color\" title=\"sum-cells-by-color\"><\/em><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y, ch\u00fang t\u00f4i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong><em>=SumCellsByColor (D2:D14, A17)<\/em><\/strong> trong \u0111\u00f3 D2: D14 l\u00e0 d\u00e3y v\u00e0 A17 l\u00e0 \u00f4 v\u1edbi m\u1ed9t m\u1eabu m\u00e0u.<\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ebfm \u00f4 v\u00e0 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u00ednh b\u1eb1ng m\u00e0u th\u00f4ng qua h\u00e0m <strong><em>CountCellsByFontColo<\/em>r <\/strong>v\u00e0 <strong><em>SumCellsByFontColor<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-cells-font-color.png\" alt=\"The formulas to count and sum cells by font color\" title=\"count-cells-font-color\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>Sau khi \u00e1p d\u1ee5ng m\u00e3 VBA, b\u1ea1n s\u1ebd c\u1ea7n th\u00eam m\u00e0u cho m\u1ed9t s\u1ed1 \u00f4 kh\u00e1c theo c\u00e1ch th\u1ee7 c\u00f4ng, t\u1ed5ng v\u00e0 s\u1ed1 \u00f4 \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ednh l\u1ea1i t\u1ef1 \u0111\u1ed9ng \u0111\u1ec3 ph\u1ea3n \u00e1nh nh\u1eefng thay \u0111\u1ed5i.<\/p>\n<p style=\"text-align: justify\">Tr\u00ean th\u1ef1c t\u1ebf, \u0111\u00f3 l\u00e0 \u0111\u1eb7c \u0111i\u1ec3m b\u00ecnh th\u01b0\u1eddng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c <strong><em>Macro<\/em><\/strong>, <strong><em>VBA scripts<\/em><\/strong> v\u00e0 h\u00e0m <strong><em>User-Defined<\/em><\/strong>. V\u1ea5n \u0111\u1ec1 l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c ch\u1ee9c n\u0103ng \u0111\u00f3 s\u1ebd \u0111i k\u00e8m v\u1edbi s\u1ef1 thay \u0111\u1ed5i d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh v\u00e0 Excel kh\u00f4ng nh\u1eadn th\u1ea5y s\u1ef1 thay \u0111\u1ed5i m\u00e0u ch\u1eef ho\u1eb7c m\u00e0u s\u1eafc c\u1ee7a \u00f4 n\u00e0y. V\u00ec v\u1eady, sau khi t\u00f4 m\u00e0u c\u00e1c \u00f4 m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng, ch\u1ec9 c\u1ea7n \u0111\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o, nh\u1ea5n <strong><em>F2<\/em><\/strong> v\u00e0 Enter, s\u1ed1 \u00f4 v\u00e0 t\u1ed5ng c\u1ee7a ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tinh_tong_va_dem_so_o_bang_mau_sac_tren_toan_bo_bang_tinh\"><\/span><strong>T\u00ednh t\u1ed5ng v\u00e0 \u0111\u1ebfm s\u1ed1 \u00f4 b\u1eb1ng m\u00e0u s\u1eafc tr\u00ean to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110o\u1ea1n VB b\u00ean d\u01b0\u1edbi \u0111\u01b0\u1ee3c vi\u1ebft theo c\u00e2u tr\u1ea3 l\u1eddi c\u1ee7a Connor (m\u1ed9t b\u1eadc th\u1ea7y Excel) v\u00e0 th\u1ef1c hi\u1ec7n ch\u00ednh x\u00e1c nh\u1eefng g\u00ec Connor y\u00eau c\u1ea7u, c\u1ee5 th\u1ec3 l\u00e0 \u0111\u1ebfm v\u00e0 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f9ng m\u00e0u trong t\u1ea5t c\u1ea3 trang t\u00ednh c\u1ee7a b\u1ea3ng t\u00ednh. V\u00ec v\u1eady, \u1edf \u0111\u00e2y c\u00f3 m\u00e3 s\u1ed1:<\/p>\n<table width=\"640\">\n<tbody>\n<tr>\n<td width=\"640\">Function WbkCountCellsByColor(cellRefColor As Range)<\/p>\n<p>Dim vWbkRes<\/p>\n<p>Dim wshCurrent As Worksheet<\/p>\n<p>\u00a0<\/p>\n<p>Application.ScreenUpdating = False<\/p>\n<p>Application.Calculation = xlCalculationManual<\/p>\n<p>\u00a0<\/p>\n<p>vWbkRes = 0<\/p>\n<p>For Each wshCurrent In Worksheets<\/p>\n<p>wshCurrent.Activate<\/p>\n<p>vWbkRes = vWbkRes + CountCellsByColor(wshCurrent.UsedRange, cellRefColor)<\/p>\n<p>Next<\/p>\n<p>Application.ScreenUpdating = True<\/p>\n<p>Application.Calculation = xlCalculationAutomatic<\/p>\n<p>\u00a0<\/p>\n<p>WbkCountCellsByColor = vWbkRes<\/p>\n<p>End Function<\/p>\n<p>\u00a0<\/p>\n<p>Function WbkSumCellsByColor(cellRefColor As Range)<\/p>\n<p>Dim vWbkRes<\/p>\n<p>Dim wshCurrent As Worksheet<\/p>\n<p>\u00a0<\/p>\n<p>Application.ScreenUpdating = False<\/p>\n<p>Application.Calculation = xlCalculationManual<\/p>\n<p>\u00a0<\/p>\n<p>vWbkRes = 0<\/p>\n<p>For Each wshCurrent In Worksheets<\/p>\n<p>wshCurrent.Activate<\/p>\n<p>vWbkRes = vWbkRes + SumCellsByColor(wshCurrent.UsedRange, cellRefColor)<\/p>\n<p>Next<\/p>\n<p>Application.ScreenUpdating = True<\/p>\n<p>Application.Calculation = xlCalculationAutomatic<\/p>\n<p>\u00a0<\/p>\n<p>WbkSumCellsByColor = vWbkRes<\/p>\n<p>End Function<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">B\u1ea1n s\u1eed d\u1ee5ng <strong><em>Macro<\/em><\/strong> t\u01b0\u01a1ng t\u1ef1 nh\u01b0 m\u00e3 tr\u01b0\u1edbc \u0111\u00f3 v\u00e0 s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c<strong><em> =WbkCountCellsColor()<\/em><\/strong> v\u00e0 <strong><em>=WbkSumCellsByColor()<\/em><\/strong>. Ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o b\u1ea5t k\u1ef3 \u00f4 tr\u1ed1ng n\u00e0o tr\u00ean trang t\u00ednh n\u1eb1m ngo\u00e0i v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn, x\u00e1c \u0111\u1ecbnh \u0111\u1ecba ch\u1ec9 \u00f4 t\u00ednh ch\u1ee9a m\u00e0u b\u1ea1n mu\u1ed1n v\u00e0o ngo\u1eb7c \u0111\u01a1n, v\u00ed d\u1ee5 <strong><em>= WbkSumCellsByColor (A1)<\/em><\/strong>, v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd hi\u1ec3n th\u1ecb t\u1ed5ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c t\u00f4 c\u00f9ng trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n<p><strong>T\u00f9y ch\u1ec9nh c\u00e1c ch\u1ee9c n\u0103ng \u0111\u1ec3 t\u00f4 m\u00e0u n\u1ec1n \u00f4, t\u00f4 m\u00e0u ch\u1eef v\u00e0 m\u00e3 m\u00e0u s\u1eafc<\/strong><\/p>\n<p style=\"text-align: justify\">\u1ede \u0111\u00e2y, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t b\u1ea3n t\u00f3m t\u1eaft t\u1ea5t c\u1ea3 c\u00e1c ch\u1ee9c n\u0103ng ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng trong v\u00ed d\u1ee5 n\u00e0y c\u0169ng nh\u01b0 m\u1ed9t v\u00e0i c\u00e1i ch\u1ee9c n\u0103ng m\u1edbi \u0111\u1ec3 l\u1ea5y m\u00e3 m\u00e0u.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong> H\u00e3y nh\u1edb r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng n\u1ebfu b\u1ea1n \u0111\u00e3 th\u00eam ch\u1ee9c n\u0103ng do ng\u01b0\u1eddi d\u00f9ng \u0111\u1ecbnh ngh\u0129a v\u00e0o b\u1ea3ng t\u00ednh Excel nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y \u1edf tr\u00ean.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chuc_nang_dem_theo_mau_sac\"><\/span><strong>Ch\u1ee9c n\u0103ng \u0111\u1ebfm theo m\u00e0u s\u1eafc:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><strong><em>CountCellsByColor (ph\u1ea1m vi, m\u00e3 m\u00e0u)<\/em><\/strong> \u2013 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 m\u00e0u n\u1ec1n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang t\u00f4i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 theo m\u00e0u =CountCellsByColor (F2: F14, A17), trong \u0111\u00f3 F2:F14 l\u00e0 v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn v\u00e0 A17 l\u00e0 \u00f4 c\u00f3 m\u00e0u n\u1ec1n c\u1ea7n thi\u1ebft. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea d\u01b0\u1edbi \u0111\u00e2y theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1.<\/p>\n<p style=\"text-align: justify\"><strong><em>CountCellsByFontColor (ph\u1ea1m vi, m\u00e3 m\u00e0u)<\/em><\/strong> \u2013 \u0111\u1ebfm c\u00e1c \u00f4 v\u1edbi m\u00e0u ch\u1eef \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p><strong>C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng b\u1eb1ng m\u00e0u s\u1eafc:<\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>SumCellsByColor (range, color code)<\/em><\/strong> \u2013 t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c \u00f4 c\u00f3 c\u00f9ng m\u00e0u n\u1ec1n.<\/p>\n<p style=\"text-align: justify\"><strong><em>SumCellsByFontColor (range, color code)<\/em><\/strong> \u2013 t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c \u00f4 c\u00f3 c\u00f9ng m\u00e0u ch\u1eef.<\/p>\n<p><strong>C\u00f4ng th\u1ee9c \u0111\u1ec3 l\u1ea5y m\u00e3 m\u00e0u:<\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>GetCellFontColor (cell)<\/em><\/strong> \u2013 tr\u1ea3 v\u1ec1 m\u00e3 m\u00e0u ch\u1eef c\u1ee7a m\u1ed9t \u00f4 x\u00e1c \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\"><strong><em>GetCellColor (cell)<\/em><\/strong> \u2013 tr\u1ea3 v\u1ec1 m\u00e3 m\u00e0u n\u1ec1n c\u1ee7a m\u1ed9t \u00f4 x\u00e1c \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cell-color-code.png\" alt=\"The formula to get the color code\" title=\"cell-color-code\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dem_va_tinh_tong_cac_o_mau_dinh_dang_co_dieu_kien\"><\/span><strong>C\u00e1ch \u0111\u1ebfm v\u00e0 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 m\u00e0u \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u00e3 <strong><em>VBA<\/em><\/strong> d\u01b0\u1edbi \u0111\u00e2y s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 \u00f4 m\u00e0u v\u00e0 t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong \u00f4, b\u1ea5t k\u1ec3 lo\u1ea1i \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng.<\/p>\n<table width=\"640\">\n<tbody>\n<tr>\n<td width=\"640\">Sub SumCountByConditionalFormat()<\/p>\n<p>Dim indRefColor As Long<\/p>\n<p>Dim cellCurrent As Range<\/p>\n<p>Dim cntRes As Long<\/p>\n<p>Dim sumRes<\/p>\n<p>Dim cntCells As Long<\/p>\n<p>Dim indCurCell As Long<\/p>\n<p>\u00a0<\/p>\n<p>cntRes = 0<\/p>\n<p>sumRes = 0<\/p>\n<p>\u00a0<\/p>\n<p>cntCells = Selection.CountLarge<\/p>\n<p>indRefColor = ActiveCell.DisplayFormat.Interior.Color<\/p>\n<p>\u00a0<\/p>\n<p>For indCurCell = 1 To (cntCells \u2013 1)<\/p>\n<p>If indRefColor = Selection(indCurCell).DisplayFormat.Interior.Color Then<\/p>\n<p>cntRes = cntRes + 1<\/p>\n<p>sumRes = WorksheetFunction.Sum(Selection(indCurCell), sumRes)<\/p>\n<p>End If<\/p>\n<p>Next<\/p>\n<p>MsgBox \u201cCount=\u201d &amp; cntRes &amp; vbCrLf &amp; \u201cSum= \u201d &amp; sumRes &amp; vbCrLf &amp; vbCrLf &amp; _<\/p>\n<p>\u201cColor=\u201d &amp; Left(\u201c000000\u201d, 6 \u2013 Len(Hex(indRefColor))) &amp; _<\/p>\n<p>Hex(indRefColor) &amp; vbCrLf, , \u201cCount &amp; Sum by Conditional Format color\u201d<\/p>\n<p>End Sub<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ma_de_dem_so_o_mau_va_tinh_tong_gia_tri_cua_chung\"><\/span><strong>C\u00e1ch s\u1eed d\u1ee5ng m\u00e3 \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 m\u00e0u v\u00e0 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol style=\"text-align: justify\">\n<li>Th\u00eam \u0111o\u1ea1n m\u00e3 tr\u00ean v\u00e0o trang t\u00ednh nh\u01b0 \u0111\u00e3 gi\u1ea3i th\u00edch \u1edf v\u00ed d\u1ee5.<\/li>\n<li>Ch\u1ecdn m\u1ed9t d\u00e3y ho\u1eb7c nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n c\u1ea7n n\u1ebfu b\u1ea1n c\u00f3 d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1.<\/li>\n<li>Nh\u1ea5n gi\u1eef ph\u00edm <strong><em>Ctrl<\/em><\/strong>, ch\u1ecdn m\u1ed9t \u00f4 t\u00ednh v\u1edbi m\u00e0u c\u1ea7n thao t\u00e1c, th\u1ea3 ph\u00edm <strong><em>Ctrl<\/em><\/strong>.<\/li>\n<li>Nh\u1ea5n <strong><em>Alt+F8<\/em><\/strong> \u0111\u1ec3 m\u1edf danh s\u00e1ch <strong><em>macros <\/em><\/strong>trong b\u1ea3ng t\u00ednh.<\/li>\n<li>Ch\u1ecdn <strong><em>SumCountByConditionalFormat<\/em><\/strong> v\u00e0 nh\u1ea5p v\u00e0o Run.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-color-cells-macro.png\" alt=\"Running a macro to count and sum cells colored using conditional formatting\" title=\"count-color-cells-macro\"><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb nh\u01b0 sau.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-color-sum.png\" alt=\"The count, sum and color code of cells colored with conditional formatting\" title=\"count-color-sum\"><\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta ch\u1ecdn c\u1ed9t Qty. v\u00e0 c\u00f3 c\u00e1c con s\u1ed1 sau:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em>Count<\/em><\/strong> l\u00e0 s\u1ed1 \u00f4 t\u00ednh trong m\u1ed9t m\u00e0u c\u1ee5 th\u1ec3, nh\u01b0 s\u1ed1 \u00f4 m\u00e0u \u0111\u1ecf trong v\u00ed d\u1ee5 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u l\u00e0 \u201cPast Due\u201d.<\/li>\n<li><strong><em>Sum<\/em><\/strong> l\u00e0 t\u1ed5ng gi\u00e1 tr\u1ecb c\u00e1c \u00f4 m\u00e0u \u0111\u1ecf trong c\u1ed9t Qty, c\u1ee5 th\u1ec3 l\u00e0 t\u1ed5ng s\u1ed1 \u00f4 \u201cPast Due\u201d.<\/li>\n<li><strong><em>Color<\/em><\/strong> l\u00e0 m\u00e3 m\u00e0u c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn, c\u1ee5 th\u1ec3 l\u00e0 \u00f4 D2.<\/li>\n<\/ul>\n<p>Qua b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta th\u1ea5y vi\u1ec7c s\u1eed d\u1ee5ng VBA trong Excel \u0111em l\u1ea1i hi\u1ec7u qu\u1ea3 r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c \u0111\u00fang kh\u00f4ng n\u00e0o.\u00a0Kh\u00f4ng ch\u1ec9 c\u00f3 v\u1eady,\u00a0VBA c\u00f2n l\u00e0m \u0111\u01b0\u1ee3c nhi\u1ec1u \u0111i\u1ec1u th\u00fa v\u1ecb h\u01a1n n\u1eefa nh\u01b0: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 word, power point, outlook\u2026 gi\u00fap bi\u1ebfn file excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p\u2026<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2PX8TK6\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/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-117.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3525,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3524","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\/3524","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=3524"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3524\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3525"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}