{"id":7896,"date":"2024-12-21T18:47:30","date_gmt":"2024-12-21T18:47:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-dem-cac-o-duoc-to-mau-trong-google-sheets-bang-power-tools-mien-phi\/"},"modified":"2024-12-21T18:47:30","modified_gmt":"2024-12-21T18:47:30","slug":"cach-dem-cac-o-duoc-to-mau-trong-google-sheets-bang-power-tools-mien-phi","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-dem-cac-o-duoc-to-mau-trong-google-sheets-bang-power-tools-mien-phi\/","title":{"rendered":"C\u00e1ch \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u trong Google Sheets b\u1eb1ng Power Tools mi\u1ec5n ph\u00ed"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u00e1nh d\u1ea5u d\u1eef li\u1ec7u b\u1eb1ng m\u00e0u trong <a href=\"http:\/\/blog.ezworkapp.com\/google-sheet-ham-query-voi-du-lieu-ngay-thang-using-google-sheet-query-function-date.html\" target=\"_blank\">Google Sheets<\/a>, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn ra r\u1eb1ng thi\u1ebfu c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u1ed5ng h\u1ee3p lo\u1ea1i th\u00f4ng tin n\u00e0y. \u0110\u00e2y l\u00e0 l\u00fd do t\u1ea1i sao ch\u00fang ta th\u00eam m\u1ed9t h\u00e0m t\u00f9y ch\u1ec9nh \u0111\u1ec3 xem ph\u00f4ng ch\u1eef v\u00e0 m\u00e0u n\u1ec1n c\u1ee7a c\u00e1c \u00f4. B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y trong s\u1ed1 c\u00e1c t\u00ednh n\u0103ng th\u00f4ng minh c\u1ee7a Power Tools. Phi\u00ean b\u1ea3n Pro hi\u1ec7n t\u1ea1i mi\u1ec5n ph\u00ed, v\u00ec v\u1eady b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 ti\u1ec7n \u00edch n\u00e0y ch\u1ec9 v\u1edbi m\u1ed9t c\u00fa nh\u1ea5p chu\u1ed9t t\u1ea1i Google Sheets Store.<\/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-67670d4129767\" 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-dem-cac-o-duoc-to-mau-trong-google-sheets-bang-power-tools-mien-phi.html#Cach_dem_cac_o_duoc_to_mau\" title=\"C\u00e1ch \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u01b0\u1ee3c t\u00f4\u00a0m\u00e0u\">C\u00e1ch \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u01b0\u1ee3c t\u00f4\u00a0m\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\/cach-dem-cac-o-duoc-to-mau-trong-google-sheets-bang-power-tools-mien-phi.html#Lam_the_nao_de_cong_cac_o_theo_mau\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed9ng c\u00e1c \u00f4\u00a0theo m\u00e0u?\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed9ng c\u00e1c \u00f4\u00a0theo m\u00e0u?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dem_cac_o_duoc_to_mau\"><\/span><strong>C\u00e1ch \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u01b0\u1ee3c t\u00f4\u00a0m\u00e0u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e3y th\u1ef1c hi\u1ec7n m\u1ed9t trong nh\u1eefng vi\u1ec7c l\u00e0m ph\u1ed5 bi\u1ebfn nh\u1ea5t \u0111\u1ed1i v\u1edbi c\u00e1c \u00f4 m\u00e0u trong b\u1ea3ng t\u00ednh: \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 c\u00f9ng \u0111\u1ecbnh d\u1ea1ng. \u1ede \u0111\u00e2y m\u00ecnh\u00a0c\u00f3 m\u1ed9t danh s\u00e1ch v\u00e0 m\u00ecnh\u00a0mu\u1ed1n bi\u1ebft s\u1ed1 l\u1ea7n h\u1ecdc sinh thi \u0111\u1eadu c\u1ee7a m\u1ed7i b\u00e0i ki\u1ec3m tra, t\u1ee9c l\u00e0 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 m\u00e0u xanh l\u00e1 c\u00e2y trong m\u1ed9t c\u1ed9t:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-43.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4559 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-43.bmp\" width=\"600\" height=\"238\" title=\"new-bitmap-image-2-43\"><\/a><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi v\u00f9ng d\u1eef li\u1ec7u t\u01b0\u01a1ng t\u1ef1 bao g\u1ed3m nh\u1eefng \u0111\u1ecbnh d\u1ea1ng kh\u00e1c: s\u1ed1, v\u0103n b\u1ea3n, ho\u1eb7c gi\u00e1 tr\u1ecb ng\u00e0y, d\u00f9ng h\u00e0m COUNTA v\u1edbi c\u00f4ng c\u1ee5 Sum By Colour.\u00a0\u0110\u1ec3 b\u1eaft \u0111\u1ea7u, m\u1edf c\u00f4ng c\u1ee5 Sum By Color. B\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y n\u00f3 n\u1ebfu b\u1ea1n x\u1ed5 xu\u1ed1ng danh s\u00e1ch AutoSum trong thanh c\u00f4ng c\u1ee5 th\u00f4ng minh c\u1ee7a Power Tools:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-44.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4560 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-44.bmp\" width=\"600\" height=\"495\" title=\"new-bitmap-image-2-44\"><\/a><\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ed1n b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n ch\u1ec9 \u0111\u1ecbnh \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><strong><em>1. Pattern cell<\/em>:<\/strong> Ch\u1ee9c n\u0103ng n\u00e0y s\u1ebd d\u00f9ng ph\u00f4ng ch\u1eef v\u00e0 m\u00e0u n\u1ec1n c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 t\u00ecm c\u00e1c \u00f4 kh\u00e1c gi\u1ed1ng n\u00f3. \u00a0m\u00ecnh\u00a0ch\u1ecdn B2 nh\u01b0 v\u00ed d\u1ee5.<\/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-324.gif\" title=\"vba101_92019-nho-324\"><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-710.gif\" title=\"ex101_92019-nho-710\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong><em>2. Source range<\/em>:<\/strong> V\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ph\u1ee7 m\u00e0u b\u1ea1n mu\u1ed1n ki\u1ec3m tra: M\u00ecnh\u00a0ch\u1ecdn c\u00e1c c\u1ed9t th\u1ec3 hi\u1ec7n k\u1ebft qu\u1ea3 ki\u1ec3m tra.<\/p>\n<p style=\"text-align: justify\"><strong><em>3. Use function: <\/em><\/strong>Khi b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng c\u1ee5 th\u1ec3, t\u1ed1t nh\u1ea5t n\u00ean ch\u1ecdn h\u00e0m COUNTA b\u1edfi v\u00ec ch\u1ec9 c\u00f3 n\u00f3 ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1. B\u1eb1ng c\u00e1ch n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 ch\u1eafc ch\u1eafn r\u1eb1ng \u0111\u1ecbnh d\u1ea1ng c\u1ee7a d\u1eef li\u1ec7u trong c\u00e1c \u00f4 s\u1ebd kh\u00f4ng \u1ea3nh h\u01b0\u1edfng k\u1ebft qu\u1ea3.<\/p>\n<p style=\"text-align: justify\"><strong><em>4. Insert function after:<\/em><\/strong> L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u00e1p d\u1ee5ng n\u00f3. Ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ecdn \u0111\u1ebfm c\u00e1c \u00f4 trong m\u1ed7i h\u00e0ng, c\u1ed9t, ho\u1eb7c trong t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn. V\u00ec m\u00ecnh\u00a0mu\u1ed1n \u0111\u1ebfm c\u00e1c \u00f4 m\u00e0u xanh l\u00e1 c\u00e2y cho m\u1ed7i b\u00e0i ki\u1ec3m tra, m\u00ecnh\u00a0ch\u1ecdn sau m\u1ed7i c\u1ed9t (<strong>Each column<\/strong>). N\u1ebfu m\u00ecnh\u00a0mu\u1ed1n m\u1ed9t k\u1ebft qu\u1ea3 t\u1ed5ng qu\u00e1t cho c\u1ea3 ba b\u00e0i ki\u1ec3m tra, m\u00ecnh\u00a0s\u1ebd ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u (<strong>Entire range<\/strong>).<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-45.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4561 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-45.bmp\" width=\"600\" height=\"370\" title=\"new-bitmap-image-2-45\"><\/a><\/p>\n<p style=\"text-align: justify\">Khi m\u00ecnh nh\u1ea5p v\u00e0o <strong><em>Insert function<\/em><\/strong>, c\u00f4ng c\u1ee5 th\u00eam c\u00f4ng th\u1ee9c d\u01b0\u1edbi m\u1ed7i c\u1ed9t, v\u00ec v\u1eady m\u00ecnh s\u1ebd th\u1ea5y k\u1ebft qu\u1ea3 cho m\u1ed7i b\u00e0i ki\u1ec3m tra.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-46.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4562 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-46.bmp\" width=\"600\" height=\"274\" title=\"new-bitmap-image-2-46\"><\/a><\/p>\n<p style=\"text-align: justify\">H\u00e3y \u0111\u1ec3 m\u00ecnh chia nh\u1ecf c\u00fa ph\u00e1p v\u00e0 gi\u1ea3i th\u00edch t\u1eebng ph\u1ea7n:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>= COUNTA<\/strong> l\u00e0 m\u1ed9t trong nh\u1eefng t\u00ednh n\u0103ng c\u1ee7a Google Sheets m\u00e0 b\u1ea1n ch\u1ecdn \u0111\u1ec3 s\u1eed d\u1ee5ng v\u1edbi c\u00e1c \u00f4 \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u.<\/li>\n<li><strong>#B6d6a8<\/strong> l\u00e0 m\u00e3 m\u00e0u c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c d\u00f9ng cho thu\u1eadt to\u00e1n, t\u1ee9c l\u00e0 m\u00e0u n\u1ec1n c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<li><strong>#000000<\/strong> l\u00e0 m\u00e0u ch\u1eef c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn. N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n d\u00f9ng m\u00e0u n\u1ec1n, b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a gi\u00e1 tr\u1ecb n\u00e0y. Sau \u0111\u00f3 c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau: = COUNTA (valuesByColor (\u201c# b6d7a8\u201d, \u201c\u201d, B2: B40)).<\/li>\n<li><strong>D2: D40<\/strong> l\u00e0 v\u00f9ng d\u1eef li\u1ec7u c\u00f3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u m\u00e0u c\u1ea7n \u0111\u1ebfm. N\u00f3 l\u00e0 c\u1ed9t D trong v\u00ed d\u1ee5 c\u1ee7a m\u00ecnh.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_cong_cac_o_theo_mau\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed9ng c\u00e1c \u00f4\u00a0theo m\u00e0u?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n A\u00a0\u0111ang theo d\u00f5i c\u00e1c \u0111\u01a1n h\u00e0ng thi\u1ebft b\u1ecb cho l\u1edbp h\u1ecdc. B\u1ea1n A ghi ch\u00fa nh\u1eefng v\u1eadt \u0111\u01b0\u1ee3c \u0111\u1eb7t h\u00e0ng b\u1eb1ng m\u00e0u v\u00e0ng, v\u1eadt \u0111ang chuy\u1ec3n t\u1edbi b\u1eb1ng m\u00e0u xanh d\u01b0\u01a1ng, v\u00e0 thi\u1ebft b\u1ecb \u0111\u00e3 giao m\u00e0u xanh l\u00e1 c\u00e2y:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-47.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4563 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-47.bmp\" width=\"600\" height=\"183\" title=\"new-bitmap-image-2-47\"><\/a><\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c c\u1ee7a b\u1ea1n A l\u00e0 xem c\u00f3 bao nhi\u00eau b\u00e0n l\u00e0m vi\u1ec7c, m\u00e1y vi t\u00ednh, v\u00e0 c\u00e1c th\u1ee9 kh\u00e1c \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n t\u1edbi. Ch\u00fang \u0111\u01b0\u1ee3c ph\u00e2n bi\u1ec7t b\u1eb1ng m\u00e0u s\u1eafc. V\u00ec v\u1eady, b\u1ea1n A m\u1edf Sum By Color v\u00e0 s\u1eed d\u1ee5ng v\u1edbi c\u00e1c c\u00e0i \u0111\u1eb7t sau:<\/p>\n<p style=\"text-align: justify\">1. B\u1ea1n A ch\u1ecdn C2 l\u00e0 \u00f4 m\u1eabu \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u1ecbnh d\u1ea1ng c\u1ee7a c\u00e1c \u00f4 m\u00ecnh mu\u1ed1n t\u00ednh to\u00e1n.<\/p>\n<p style=\"text-align: justify\">2. B\u1ea1n A\u00a0ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ec3 ki\u1ec3m tra.<\/p>\n<p style=\"text-align: justify\">3. Sau \u0111\u00f3 ch\u1ecdn <a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-trung-binh-trong-so-trong-excel-bang-ham-sum-hoac-sumproduct.html\" target=\"_blank\">h\u00e0m SUM<\/a> \u0111\u1ec3 c\u1ed9ng c\u00e1c s\u1ed1 c\u1ee7a \u00f4 m\u00e0u xanh l\u00e1 c\u00e2y.<\/p>\n<p style=\"text-align: justify\">4. \u0110\u1ec3 xem s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng \u0111\u00e3 giao c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m, \u00e1p d\u1ee5ng h\u00e0m cho m\u1ed7i h\u00e0ng<strong> (each row)<\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-48.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4564 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-48.bmp\" width=\"524\" height=\"337\" title=\"new-bitmap-image-2-48\"><\/a><\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p v\u00e0o <strong>Insert function<\/strong> \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c sau m\u1ed7i d\u00f2ng trong b\u1ea3ng.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-49.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4565 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-49.bmp\" width=\"600\" height=\"203\" title=\"new-bitmap-image-2-49\"><\/a><\/p>\n<p style=\"text-align: justify\">S\u1ef1 thu\u1eadn ti\u1ec7n khi c\u00f3 c\u00f4ng th\u1ee9c l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eeda \u0111\u1ed5i b\u1ea5t k\u1ef3 b\u1ed9 ph\u1eadn n\u00e0o c\u1ee7a n\u00f3 v\u00e0 d\u00e1n n\u00f3 v\u00e0o b\u1ea5t c\u1ee9 n\u01a1i n\u00e0o b\u1ea1n c\u1ea7n trong Google Sheets.<\/p>\n<p style=\"text-align: justify\"><strong>C\u1eadp nh\u1eadt k\u1ebft qu\u1ea3<\/strong><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 nh\u1edb r\u1eb1ng Google Sheets kh\u00f4ng c\u00f3 c\u00e1c ch\u1ee9c n\u0103ng l\u00e0m vi\u1ec7c v\u1edbi m\u00e0u s\u1eafc kh\u00f4ng? \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 ch\u00fang kh\u00f4ng xem s\u1ef1 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u00f4 nh\u01b0 l\u00e0 m\u1ed9t l\u00fd do \u0111\u1ec3 t\u00ednh l\u1ea1i c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n. Tin vui l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng hai gi\u1ea3i ph\u00e1p r\u1ea5t \u0111\u01a1n gi\u1ea3n sau.<\/p>\n<p style=\"text-align: justify\">1. B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o trong v\u00f9ng d\u1eef li\u1ec7u. B\u1ea1n \u0111ang \u0111\u1ebfm c\u00e1c \u00f4 m\u00e0u xanh l\u00e1 c\u00e2y trong A1: C254. B\u1ea1n ch\u1ec9 c\u1ea7n th\u00eam k\u00fd t\u1ef1 v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong v\u00f9ng n\u00e0y, v\u00e0 sau \u0111\u00f3 x\u00f3a n\u00f3 \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1eadp nh\u1eadt.<\/p>\n<p style=\"text-align: justify\">2. N\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u c\u00f4ng th\u1ee9c <strong><em>valuesByColor<\/em><\/strong> trong trang t\u00ednh, h\u00e3y nh\u1ea5p v\u00e0o t\u00f9y ch\u1ecdn <strong>Refresh<\/strong> \u1edf b\u00ean c\u1ea1nh <strong>Sum By Color<\/strong> trong Power Tools \u0111\u1ec3 c\u1eadp nh\u1eadt t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c trong m\u1ed9t l\u1ea7n.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-50.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4566 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-50.bmp\" width=\"600\" height=\"480\" title=\"new-bitmap-image-2-50\"><\/a><\/p>\n<p style=\"text-align: justify\"><strong>X\u1eed l\u00fd s\u1ef1 c\u1ed1<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n th\u1ea5y l\u1ed7i \u1edf v\u1ecb tr\u00ed c\u00f4ng th\u1ee9c, c\u00f3 th\u1ec3 b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi file ch\u01b0a c\u00e0i \u0111\u1eb7t ng\u00f4n ng\u1eef. Khi \u0111i\u1ec1u n\u00e0y x\u1ea3y ra, c\u00f4ng th\u1ee9c kh\u00f4ng bi\u1ebft nh\u1eefng d\u1ea5u ph\u00e2n c\u00e1ch n\u00ean s\u1eed d\u1ee5ng, v\u00ec v\u1eady b\u00e1o l\u1ed7i. N\u1ebfu b\u1ea1n g\u1eb7p \u0111i\u1ec1u n\u00e0y, vui l\u00f2ng ch\u1ecdn <em>File -&gt; Spreadsheet setting\u2026<\/em> trong Google Sheets v\u00e0 c\u00e0i \u0111\u1eb7t ng\u00f4n ng\u1eef.<\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel \u1edf \u0111\u00e2u t\u1ed1t<\/a>?<\/p>\n<\/blockquote>\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-324.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7897,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7896","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\/7896","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=7896"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7896\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7897"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}