{"id":3337,"date":"2024-12-03T02:13:34","date_gmt":"2024-12-03T02:13:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac\/"},"modified":"2024-12-03T02:13:34","modified_gmt":"2024-12-03T02:13:34","slug":"cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac\/","title":{"rendered":"C\u00f4ng th\u1ee9c Excel \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb \u00f4 kh\u00e1c"},"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=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel, c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c Excel \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng t\u1eebng \u00f4 v\u00e0 to\u00e0n b\u1ed9 h\u00e0ng d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n ch\u1ec9 \u0111\u1ecbnh ho\u1eb7c d\u1ef1a v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 kh\u00e1c, <em><strong>\u0111\u1ed5i m\u00e0u \u00f4 excel theo \u0111i\u1ec1u ki\u1ec7n.\u00a0<\/strong><\/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-674e694d6dcb8\" 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\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Cong_thuc_dinh_dang_co_dieu_kien_dua_tren_gia_tri_mot_o_doi_mau_o_excel_theo_dieu_kien\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb m\u1ed9t \u00f4, \u0111\u1ed5i m\u00e0u \u00f4 excel theo \u0111i\u1ec1u ki\u1ec7n\">C\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb m\u1ed9t \u00f4, \u0111\u1ed5i m\u00e0u \u00f4 excel theo \u0111i\u1ec1u ki\u1ec7n<\/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\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Cach_tao_quy_tac_dinh_dang_co_dieu_kien_su_dung_cong_thuc\" title=\"C\u00e1ch t\u1ea1o quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\">C\u00e1ch t\u1ea1o quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/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\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Cac_vi_du_cong_thuc_dinh_dang_theo_dinh_dang_co_dieu_kien_cua_Excel\" title=\"C\u00e1c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng theo \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel\">C\u00e1c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng theo \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel<\/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\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Cong_thuc_de_so_sanh_cac_gia_tri_so_va_van_ban\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ec3 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb (s\u1ed1 v\u00e0 v\u0103n b\u1ea3n)\">C\u00f4ng th\u1ee9c \u0111\u1ec3 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb (s\u1ed1 v\u00e0 v\u0103n b\u1ea3n)<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Ham_AND_va_OR\" title=\"H\u00e0m AND v\u00e0 OR\">H\u00e0m AND v\u00e0 OR<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Dinh_dang_co_dieu_kien_cho_o_trong_va_khong_trong\" title=\"\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng\">\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Cong_thuc_Excel_lam_viec_voi_cac_gia_tri_van_ban\" title=\"C\u00f4ng th\u1ee9c Excel l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n\">C\u00f4ng th\u1ee9c Excel l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Cong_thuc_Excel_de_lam_noi_bat_cac_phan_trung_lap\" title=\"C\u00f4ng th\u1ee9c Excel \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c ph\u1ea7n tr\u00f9ng l\u1eb7p\">C\u00f4ng th\u1ee9c Excel \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c ph\u1ea7n tr\u00f9ng l\u1eb7p<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Lam_noi_bat_du_lieu_trung_lap_bao_gom_lan_dau_xuat_hien\" title=\"L\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p bao \u00a0g\u1ed3m\u00a0l\u1ea7n \u0111\u1ea7u xu\u1ea5t hi\u1ec7n\">L\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p bao \u00a0g\u1ed3m\u00a0l\u1ea7n \u0111\u1ea7u xu\u1ea5t hi\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Lam_noi_bat_du_lieu_trung_lap_khong_bao_gom_lan_dau_xuat_hien\" title=\"L\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p kh\u00f4ng bao \u00a0g\u1ed3m\u00a0l\u1ea7n \u0111\u1ea7u xu\u1ea5t hi\u1ec7n\">L\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p kh\u00f4ng bao \u00a0g\u1ed3m\u00a0l\u1ea7n \u0111\u1ea7u xu\u1ea5t hi\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Lam_noi_bat_cac_du_lieu_trung_lien_tiep_trong_Excel\" title=\"L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng li\u00ean ti\u1ebfp trong Excel\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng li\u00ean ti\u1ebfp trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Danh_dau_cac_hang_trung\" title=\"\u0110\u00e1nh d\u1ea5u c\u00e1c h\u00e0ng tr\u00f9ng\">\u0110\u00e1nh d\u1ea5u c\u00e1c h\u00e0ng tr\u00f9ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#So_sanh_hai_cot_trung_lap\" title=\"So s\u00e1nh hai c\u1ed9t tr\u00f9ng l\u1eb7p\">So s\u00e1nh hai c\u1ed9t tr\u00f9ng l\u1eb7p<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Cong_thuc_de_lam_noi_bat_cac_gia_tri_o_tren_hoac_duoi_trung_binh\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb \u1edf tr\u00ean ho\u1eb7c d\u01b0\u1edbi trung b\u00ecnh\">C\u00f4ng th\u1ee9c \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb \u1edf tr\u00ean ho\u1eb7c d\u01b0\u1edbi trung b\u00ecnh<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Cach_lam_noi_bat_gia_tri_gan_nhat_trong_Excel\" title=\"C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t trong Excel\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html#Tai_sao_dinh_dang_co_dieu_kien_Excel_cua_toi_khong_hoat_dong_dung\" title=\"T\u1ea1i sao \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Excel c\u1ee7a t\u00f4i kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang?\">T\u1ea1i sao \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Excel c\u1ee7a t\u00f4i kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u0111\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=\"Cong_thuc_dinh_dang_co_dieu_kien_dua_tren_gia_tri_mot_o_doi_mau_o_excel_theo_dieu_kien\"><\/span><strong>C\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb m\u1ed9t \u00f4, \u0111\u1ed5i m\u00e0u \u00f4 excel theo \u0111i\u1ec1u ki\u1ec7n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc c\u1ee7a Excel ch\u1ee7 y\u1ebfu nh\u1eb1m \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean m\u1ed9t \u00f4 kh\u00e1c ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng to\u00e0n b\u1ed9 h\u00e0ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4, th\u00ec b\u1ea1n s\u1ebd c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Excel.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_quy_tac_dinh_dang_co_dieu_kien_su_dung_cong_thuc\"><\/span><strong>C\u00e1ch t\u1ea1o quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi c\u1ee7a Excel 2016, Excel 2013, Excel 2010 v\u00e0 Excel 2007, t\u00ednh n\u0103ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u1eb1m \u1edf <em>Home<\/em>\u00a0tab &gt;\u00a0<em>Styles<\/em>\u00a0.\u00a0Trong Excel 2003, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y n\u00f3 d\u01b0\u1edbi\u00a0menu\u00a0<em>Format\u00a0<\/em>\u00a0.<\/p>\n<p style=\"text-align: justify\">V\u00ec v\u1eady, b\u1ea1n thi\u1ebft l\u1eadp m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean m\u1ed9t c\u00f4ng th\u1ee9c theo c\u00e1ch n\u00e0y:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng.\u00a0B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t c\u1ed9t, m\u1ed9t v\u00e0i c\u1ed9t ho\u1eb7c to\u00e0n b\u1ed9 b\u1ea3ng n\u1ebfu b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a m\u00ecnh cho nhi\u1ec1u h\u00e0ng.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>: N\u1ebfu b\u1ea1n d\u1ef1 \u0111\u1ecbnh s\u1ebd nh\u1eadp th\u00eam nhi\u1ec1u d\u1eef li\u1ec7u trong t\u01b0\u01a1ng lai v\u00e0 b\u1ea1n mu\u1ed1n quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng cho c\u00e1c m\u1ee5c nh\u1eadp m\u1edbi, b\u1ea1n c\u00f3 th\u1ec3:<\/p>\n<ul style=\"text-align: justify\">\n<li>Chuy\u1ec3n \u0111\u1ed5i m\u1ed9t d\u00e3y c\u00e1c \u00f4 sang m\u1ed9t b\u1ea3ng (\u00a0<em>Insert tab&gt; Table<\/em>\u00a0).\u00a0Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng cho t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng m\u1edbi.<\/li>\n<li>Ch\u1ecdn m\u1ed9t s\u1ed1 h\u00e0ng tr\u1ed1ng b\u00ean d\u01b0\u1edbi d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, v\u00ed d\u1ee5 100 h\u00e0ng tr\u1ed1ng.<\/li>\n<\/ul>\n<blockquote>\n<p>Ti\u0300m hi\u00ea\u0309u ngay:\u00a0H\u1ecdc Excel n\u00e2ng cao \u1edf \u0111\u00e2u?<\/p>\n<\/blockquote>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Ch\u1ecdn\u00a0<strong>Conditional formatting &gt; New Rule\u2026<\/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\/conditional-format-rule-excel2013.png\" alt=\"Creating a new conditional formatting rule using a formula\" title=\"conditional-format-rule-excel2013\"><\/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-111.gif\" title=\"vba101_92019-nho-111\"><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-257.gif\" title=\"ex101_92019-nho-257\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Trong <em>New Formatting Rule window<\/em>, ch\u1ecdn <strong><em>Use a formula to determine which cells to format<\/em><\/strong>.<\/li>\n<li>Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o h\u1ed9p t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<li>Nh\u1ea5p v\u00e0o n\u00fat\u00a0<strong>F<\/strong><strong>ormat\u2026 <\/strong>\u0111\u1ec3 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh 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\/conditional-format-rule-formula.png\" alt=\"Enter the formula and click the Format\u2026 button to choose your custom format.\" title=\"conditional-format-rule-formula\"><\/p>\n<ol style=\"text-align: justify\" start=\"6\">\n<li>Chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c tab\u00a0<strong>Font<\/strong>,\u00a0<strong>Border<\/strong>\u00a0v\u00e0\u00a0<strong>Fill<\/strong>\u00a0v\u00e0 s\u1eed d\u1ee5ng v\u1edbi c\u00e1c t\u00f9y ch\u1ecdn kh\u00e1c nhau nh\u01b0 ki\u1ec3u ph\u00f4ng ch\u1eef, m\u00e0u m\u1eabu v\u00e0 hi\u1ec7u \u1ee9ng \u0111\u1ed5 \u0111\u1ec3 thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p nh\u1ea5t cho b\u1ea1n.\u00a0N\u1ebfu b\u1ea3ng m\u00e0u chu\u1ea9n kh\u00f4ng \u0111\u1ee7, h\u00e3y nh\u1ea5p v\u00e0o\u00a0<strong>More colors\u2026<\/strong>\u00a0v\u00e0 ch\u1ecdn b\u1ea5t k\u1ef3 m\u00e0u RGB ho\u1eb7c HSL n\u00e0o theo \u00fd th\u00edch c\u1ee7a b\u1ea1n.\u00a0Khi ho\u00e0n t\u1ea5t, nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>OK<\/em>.<\/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-fill-color.png\" alt=\"Switch between the Font, Border and Fill tab and set up your custom format.\" title=\"custom-fill-color\"><\/p>\n<ol style=\"text-align: justify\" start=\"7\">\n<li>\u0110\u1ea3m b\u1ea3o ph\u1ea7n\u00a0<strong>Preview\u00a0 <\/strong>hi\u1ec3n th\u1ecb \u0111\u1ecbnh d\u1ea1ng m\u00e0 b\u1ea1n mu\u1ed1n v\u00e0 n\u1ebfu \u0111\u1ed3ng \u00fd, h\u00e3y nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>OK\u00a0<\/em>\u0111\u1ec3 l\u01b0u quy t\u1eafc.\u00a0N\u1ebfu b\u1ea1n kh\u00f4ng h\u00e0i l\u00f2ng v\u1edbi b\u1ea3n xem tr\u01b0\u1edbc \u0111\u1ecbnh d\u1ea1ng, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat\u00a0<em>Format \u2026<\/em>\u00a0m\u1ed9t l\u1ea7n n\u1eefa v\u00e0 th\u1ef1c hi\u1ec7n ch\u1ec9nh s\u1eeda.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/save-conditional-format-rule.png\" alt=\"Make sure the Preview section displays the format you want and save the rule.\" title=\"save-conditional-format-rule\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>: <strong>\u00a0<\/strong>B\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n c\u1ea7n ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n (\u0111\u1ed5i \u00f4 m\u00e0u excel c\u00f3 \u0111i\u1ec1u ki\u1ec7n), h\u00e3y nh\u1ea5n F2 v\u00e0 sau \u0111\u00f3 di chuy\u1ec3n \u0111\u1ebfn v\u1ecb tr\u00ed c\u1ea7n thi\u1ebft trong c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1c ph\u00edm m\u0169i t\u00ean. N\u1ebfu b\u1ea1n d\u00f9ng m\u0169i t\u00ean m\u00e0 kh\u00f4ng nh\u1ea5n F2 , m\u1ed9t d\u00e3y s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o c\u00f4ng th\u1ee9c thay v\u00ec ch\u1ec9 di chuy\u1ec3n con tr\u1ecf ch\u00e8n. \u0110\u1ec3 th\u00eam m\u1ed9t tham chi\u1ebfu \u00f4 nh\u1ea5t \u0111\u1ecbnh v\u00e0o c\u00f4ng th\u1ee9c, nh\u1ea5n F2 m\u1ed9t l\u1ea7n n\u1eefa v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o \u00f4 \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_vi_du_cong_thuc_dinh_dang_theo_dinh_dang_co_dieu_kien_cua_Excel\"><\/span><strong>C\u00e1c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng theo \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch t\u1ea1o v\u00e0 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel, \u0111\u1ed5i \u00f4 m\u00e0u excel theo \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean m\u1ed9t \u00f4 kh\u00e1c, ch\u00fang ta h\u00e3y ti\u1ebfp t\u1ee5c v\u00e0 xem c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c Excel kh\u00e1c nhau trong th\u1ef1c t\u1ebf:<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_de_so_sanh_cac_gia_tri_so_va_van_ban\"><\/span><strong>C\u00f4ng th\u1ee9c \u0111\u1ec3 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb (s\u1ed1 v\u00e0 v\u0103n b\u1ea3n)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft Microsoft Excel cung c\u1ea5p m\u1ed9t s\u1ed1 \u00edt c\u00e1c quy t\u1eafc s\u1eb5n d\u00f9ng \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh (<em>Conditional Formatting &gt;Highlight Cells Rules<\/em>). Tuy nhi\u00ean, c\u00e1c quy t\u1eafc n\u00e0y kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00e1c c\u1ed9t nh\u1ea5t \u0111\u1ecbnh ho\u1eb7c to\u00e0n b\u1ed9 h\u00e0ng <strong>d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 trong m\u1ed9t c\u1ed9t kh\u00e1<\/strong>c. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6111\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1.jpg\" width=\"405\" height=\"270\" title=\"1\"><\/p>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y m\u1ed9t v\u00ed d\u1ee5 v\u1ec1\u00a0<strong>C\u00f4ng th\u1ee9c l\u1edbn h\u01a1n, <\/strong>\u00a0l\u00e0m n\u1ed5i b\u1eadt c\u00e1c t\u00ean s\u1ea3n ph\u1ea9m trong c\u1ed9t A n\u1ebfu s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng t\u1ed3n kho (c\u1ed9t C) l\u1edbn h\u01a1n 0. H\u00e3y ch\u00fa \u00fd r\u1eb1ng c\u00f4ng th\u1ee9c ch\u1ec9 \u00e1p d\u1ee5ng cho c\u1ed9t A ($ A $ 2: $ A $ 8).\u00a0Nh\u01b0ng n\u1ebfu b\u1ea1n ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, $ A $ 2: $ E $ 8), \u0111i\u1ec1u n\u00e0y s\u1ebd l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb trong c\u1ed9t C.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6112\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-127.png\" width=\"600\" height=\"485\" title=\"excel-dialog-box-launcher-1-127\"><\/p>\n<p style=\"text-align: justify\">B\u1eb1ng c\u00e1ch t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a hai \u00f4.\u00a0V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong>=$A2&lt;$B2<\/strong>\u00a0\u2013 \u0110\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 ho\u1eb7c c\u00e1c h\u00e0ng n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t A nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B.<\/p>\n<p style=\"text-align: justify\"><strong>=$A2=$B2<\/strong>\u00a0\u2013 \u0111\u1ecbnh d\u1ea1ng \u00f4 ho\u1eb7c c\u00e1c h\u00e0ng n\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c c\u1ed9t A v\u00e0 B l\u00e0 gi\u1ed1ng nhau.<\/p>\n<p style=\"text-align: justify\"><strong>=$A2&lt;&gt;$B2<\/strong>\u00a0\u2013 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 ho\u1eb7c c\u00e1c h\u00e0ng n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t A kh\u00f4ng gi\u1ed1ng nh\u01b0 trong c\u1ed9t B.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00e1c c\u00f4ng th\u1ee9c d\u00f9ng c\u1ea3 cho c\u00e1c c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n c\u0169ng nh\u01b0 cho c\u00e1c con s\u1ed1.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/formula-compare-cells.png\" alt=\"Excel formulas to compare cells with text values\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_AND_va_OR\"><\/span><strong>H\u00e0m<\/strong><strong> AND v\u00e0 OR<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng Excel c\u1ee7a b\u1ea1n d\u1ef1a tr\u00ean 2 ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, th\u00ec h\u00e3y s\u1eed d\u1ee5ng h\u00e0m =AND V\u00c0 = OR:<\/p>\n<table style=\"height: 273px;width: 589px\">\n<tbody>\n<tr>\n<td style=\"width: 148.75px\"><strong>\u0110i\u1ec1u ki\u1ec7n<\/strong><\/td>\n<td style=\"width: 137.841px\"><strong>C\u00f4ng th\u1ee9c<\/strong><\/td>\n<td style=\"width: 265.114px\"><strong>M<\/strong><strong>i\u00eau t\u1ea3<\/strong><\/td>\n<td style=\"width: 9.65909px\"><strong>\u00a0<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 148.75px\">N\u1ebfu c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng<\/td>\n<td style=\"width: 137.841px\"><strong>=AND($B2&lt;$C2, $C2&lt;$D2)<\/strong><\/td>\n<td style=\"width: 265.114px\">\u0110\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 n\u1ebfu gi\u00e1 tr\u1ecb trong c\u1ed9t B nh\u1ecf h\u01a1n c\u1ed9t C,\u00a0<strong>v\u00e0<\/strong>\u00a0n\u1ebfu gi\u00e1 tr\u1ecb trong c\u1ed9t C nh\u1ecf h\u01a1n trong c\u1ed9t D.<\/td>\n<td style=\"width: 9.65909px\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 148.75px\">N\u1ebfu m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng<\/td>\n<td style=\"width: 137.841px\"><strong>=OR($B2&lt;$C2, $C2&lt;$D2)<\/strong><\/td>\n<td style=\"width: 265.114px\">\u0110\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 n\u1ebfu gi\u00e1 tr\u1ecb trong c\u1ed9t B nh\u1ecf h\u01a1n c\u1ed9t C,\u00a0<strong>ho\u1eb7c<\/strong>\u00a0n\u1ebfu gi\u00e1 tr\u1ecb trong c\u1ed9t C nh\u1ecf h\u01a1n trong c\u1ed9t D.<\/td>\n<td style=\"width: 9.65909px\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">Trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, ch\u00fang t\u00f4i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\u00a0<strong>=AND($C2&gt;0, $D2=\u201dWorldwide\u201d) <\/strong>\u0111\u1ec3 thay \u0111\u1ed5i m\u00e0u n\u1ec1n c\u1ee7a c\u00e1c h\u00e0ng n\u1ebfu s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng t\u1ed3n kho (C\u1ed9t C) l\u1edbn h\u01a1n 0 v\u00e0 n\u1ebfu s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c v\u1eadn chuy\u1ec3n tr\u00ean to\u00e0n th\u1ebf gi\u1edbi [<strong>Worldwide<\/strong>] (C\u1ed9t D).\u00a0H\u00e3y l\u01b0u \u00fd r\u1eb1ng c\u00f4ng th\u1ee9c n\u00e0y ho\u1ea1t \u0111\u1ed9ng v\u1edbi\u00a0<strong>c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n<\/strong>\u00a0c\u0169ng nh\u01b0 v\u1edbi c\u00e1c\u00a0<strong>con s\u1ed1<\/strong>\u00a0.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6113\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-128.png\" width=\"600\" height=\"495\" title=\"excel-dialog-box-launcher-1-128\"><\/p>\n<p style=\"text-align: justify\">\u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng hai, ba ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m = AND v\u00e0 = OR c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u01a1 b\u1ea3n b\u1ea1n s\u1eed d\u1ee5ng trong Excel.\u00a0B\u00e2y gi\u1edd ch\u00fang ta h\u00e3y xem x\u00e9t m\u1ed9t v\u00ed d\u1ee5 ph\u1ee9c t\u1ea1p h\u01a1n nh\u01b0ng th\u00fa v\u1ecb h\u01a1n nhi\u1ec1u.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_co_dieu_kien_cho_o_trong_va_khong_trong\"><\/span><strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">T\u00f4i ngh\u0129 m\u1ecdi ng\u01b0\u1eddi \u0111\u1ec1u bi\u1ebft l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 tr\u1ed1ng tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng trong Excel \u2013 b\u1ea1n ch\u1ec9 c\u1ea7n t\u1ea1o m\u1ed9t quy t\u1eafc m\u1edbi cho c\u00e1c \u00f4 \u201d\u00a0<em>\u201cFormat only cells that contain \u201c<\/em>\u00a0v\u00e0 ch\u1ecdn m\u1ed9t trong hai \u00f4\u00a0<strong>Blanks\u00a0<\/strong>ho\u1eb7c<strong>\u00a0No Blanks.<\/strong><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6114\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-129.png\" width=\"598\" height=\"334\" title=\"excel-dialog-box-launcher-1-129\"> <\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng \u0111i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 trong m\u1ed9t c\u1ed9t nh\u1ea5t \u0111\u1ecbnh n\u1ebfu m\u1ed9t \u00f4 t\u01b0\u01a1ng \u1ee9ng trong m\u1ed9t c\u1ed9t kh\u00e1c tr\u1ed1ng ho\u1eb7c kh\u00f4ng tr\u1ed1ng?\u00a0Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c Excel m\u1ed9t l\u1ea7n n\u1eefa:<\/p>\n<p style=\"text-align: justify\"><strong>C\u00f4ng th\u1ee9c cho kho\u1ea3ng tr\u1ed1ng<\/strong>\u00a0:\u00a0<strong>=$B2=\u201d\u201d<\/strong>\u2013 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 \/ h\u00e0ng \u0111\u00e3 ch\u1ecdn n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng trong C\u1ed9t B tr\u1ed1ng.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00f4ng th\u1ee9c cho kh\u00f4ng kho\u1ea3ng tr\u1ed1ng<\/strong>\u00a0:\u00a0<strong>=$B2&lt;&gt;\u201d\u201d<\/strong>\u2013 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 \/ h\u00e0ng \u0111\u00e3 ch\u1ecdn n\u1ebfu m\u1ed9t \u00f4 t\u01b0\u01a1ng \u1ee9ng trong C\u1ed9t B kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa th\u00edch.\u00a0<\/strong>C\u00e1c c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd l\u00e0m vi\u1ec7c cho c\u00e1c \u00f4 \u201chi\u1ec7n ra\u201d tr\u1ed1ng ho\u1eb7c kh\u00f4ng tr\u1ed1ng.\u00a0N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 h\u00e0m Excel tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i r\u1ed7ng, v\u00ed d\u1ee5\u00a0<strong>=if(false,\u201dOK\u201d, \u201c\u201d)<\/strong>, v\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n c\u00e1c \u00f4 nh\u01b0 v\u1eady \u0111\u01b0\u1ee3c coi l\u00e0 kho\u1ea3ng tr\u1eafng, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c sau \u0111\u00e2y\u00a0<strong>=isblank(A1)=true<\/strong>ho\u1eb7c\u00a0<strong>=isblank(A1)=false<\/strong>\u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng, t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean trong th\u1ef1c t\u1ebf.\u00a0Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t c\u1ed9t (B) l\u00e0 \u201d\u00a0<em>Date of Sale<\/em>\u00a0\u201d v\u00e0 m\u1ed9t c\u1ed9t kh\u00e1c (C) \u201d\u00a0<em>Delivery\u201d <\/em>\u201c.\u00a0Hai c\u1ed9t n\u00e0y ch\u1ec9 c\u00f3 gi\u00e1 tr\u1ecb khi h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c b\u00e1n v\u00e0 giao nh\u1eadn.\u00a0V\u00ec v\u1eady, b\u1ea1n mu\u1ed1n to\u00e0n b\u1ed9 h\u00e0ng chuy\u1ec3n sang m\u00e0u da cam khi b\u1ea1n \u0111\u00e3 b\u00e1n h\u00e0ng;\u00a0V\u00e0 khi m\u1ed9t v\u1eadt ph\u1ea9m \u0111\u01b0\u1ee3c giao, m\u1ed9t h\u00e0ng t\u01b0\u01a1ng \u1ee9ng s\u1ebd chuy\u1ec3n sang m\u00e0u xanh l\u00e1 c\u00e2y.\u00a0\u0110\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i t\u1ea1o ra 2 quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>H\u00e0ng cam (m\u1ed9t \u00f4 trong c\u1ed9t B kh\u00f4ng r\u1ed7ng):\u00a0<strong>=$B2&lt;&gt;\u201d\u201d<\/strong><\/li>\n<li>C\u00e1c h\u00e0ng m\u00e0u xanh l\u1ee5c (c\u00e1c \u00f4 trong c\u1ed9t B v\u00e0 c\u1ed9t C kh\u00f4ng r\u1ed7ng):\u00a0<strong>=AND($B2&lt;&gt;\u201d\u201d, $C2&lt;&gt;\u201d\u201d)<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">M\u1ed9t \u0111i\u1ec1u n\u1eefa b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 \u0111\u01b0a quy t\u1eafc th\u1ee9 hai l\u00ean tr\u00ean c\u00f9ng v\u00e0 ch\u1ecdn\u00a0h\u1ed9p ki\u1ec3m\u00a0<em>Stop if true <\/em>b\u00ean c\u1ea1nh quy t\u1eafc n\u00e0y:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6115\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-130.png\" width=\"600\" height=\"485\" title=\"excel-dialog-box-launcher-1-130\"><\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3 n\u00e0y, t\u00f9y ch\u1ecdn \u201cStop if true \u201d th\u1ef1c s\u1ef1 kh\u00f4ng c\u1ea7n thi\u1ebft, v\u00e0 quy t\u1eafc s\u1ebd l\u00e0m vi\u1ec7c b\u1ea5t k\u1ec3 c\u00f3 hay kh\u00f4ng c\u00f3 n\u00f3.\u00a0B\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh d\u1ea5u v\u00e0o h\u1ed9p n\u00e0y ch\u1ec9 nh\u01b0 m\u1ed9t bi\u1ec7n ph\u00e1p ph\u00f2ng ng\u1eeba b\u1ed5 sung, trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n th\u00eam m\u1ed9t v\u00e0i quy t\u1eafc kh\u00e1c trong t\u01b0\u01a1ng lai c\u00f3 th\u1ec3 xung \u0111\u1ed9t v\u1edbi b\u1ea5t k\u1ef3 tr\u01b0\u1eddng h\u1ee3p n\u00e0o hi\u1ec7n c\u00f3.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_Excel_lam_viec_voi_cac_gia_tri_van_ban\"><\/span><strong>C\u00f4ng th\u1ee9c Excel l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn khi m\u1ed9t \u00f4 kh\u00e1c trong c\u00f9ng m\u1ed9t h\u00e0ng ch\u1ee9a m\u1ed9t t\u1eeb nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n nh\u01b0\u00a0<strong>=$D2=\u201dWorldwide\u201d<\/strong>(ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 trong m\u1ed9t trong c\u00e1c v\u00ed d\u1ee5 tr\u01b0\u1edbc \u0111\u00f3).\u00a0Tuy nhi\u00ean, c\u00f4ng th\u1ee9c n\u00e0y s\u1ebd l\u00e0m vi\u1ec7c cho\u00a0<strong>t\u1eeb ch\u00ednh x\u00e1c<\/strong>\u00a0.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi\u00a0<strong>t\u1eeb ch\u1ec9 \u0111\u00fang m\u1ed9t ph\u1ea7n<\/strong>\u00a0, b\u1ea1n s\u1ebd c\u1ea7n m\u1ed9t h\u00e0m Excel kh\u00e1c:\u00a0<em>SEARCH ()<\/em>\u00a0B\u1ea1n s\u1eed d\u1ee5ng n\u00f3 theo c\u00e1ch n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>=SEARCH(\u201cWorldwide\u201d, $D2)&gt;0<\/strong>\u2013 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 ho\u1eb7c h\u00e0ng n\u1ebfu m\u1ed9t \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t D ch\u1ee9a t\u1eeb \u201d\u00a0<em>Worldwide<\/em>\u00a0\u201c.\u00a0C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd t\u00ecm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u00f3, b\u1ea5t k\u1ec3 v\u1ecb tr\u00ed c\u1ee7a v\u0103n b\u1ea3n t\u00ecm ki\u1ebfm n\u1eb1m trong m\u1ed9t \u00f4, v\u00ed d\u1ee5 nh\u01b0 \u201d\u00a0<em>\u201cShips Worldwide\u201d,<\/em> <em>\u201cWorldwide, except for\u2026\u201d <\/em>\u201d vv<\/p>\n<p style=\"text-align: justify\"><strong>=SEARCH(\u201cWorldwide\u201d, $D2)&gt;1<\/strong>\u00a0\u2013 \u0111\u1ed5 b\u00f3ng c\u00e1c \u00f4 ho\u1eb7c h\u00e0ng n\u1ebfu n\u1ed9i dung c\u1ee7a \u00f4 b\u1eaft \u0111\u1ea7u b\u1eb1ng v\u0103n b\u1ea3n t\u00ecm ki\u1ebfm.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/formula-text-values.png\" alt=\"Excel formulas to conditionally format cells based on text values\" title=\"formula-text-values\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_Excel_de_lam_noi_bat_cac_phan_trung_lap\"><\/span><strong>C\u00f4ng th\u1ee9c Excel \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c ph\u1ea7n tr\u00f9ng l\u1eb7p<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, b\u1ea1n c\u00f3 d\u00f9ng c\u00e1c nguy\u00ean t\u1eafc \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc c\u00f3 s\u1eb5n d\u01b0\u1edbi\u00a0<em>Conditional formatting &gt; Highlight Cells Rules &gt; Duplicate Value. <\/em><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, d\u1eef li\u1ec7u s\u1ebd t\u1ed1t h\u01a1n n\u1ebfu b\u1ea1n t\u00f4 m\u00e0u c\u00e1c c\u1ed9t \u0111\u00e3 ch\u1ecdn ho\u1eb7c to\u00e0n b\u1ed9 h\u00e0ng khi c\u00f3 gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p x\u1ea3y ra trong m\u1ed9t c\u1ed9t kh\u00e1c.\u00a0Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng l\u1ea1i c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n Excel, v\u00e0 l\u1ea7n n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-trong-excel-huong-dan-cu-va-co-vi-du-minh-hoa.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m\u00a0<em>COUNTIF<\/em><\/a>\u00a0.\u00a0Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, h\u00e0m Excel n\u00e0y \u0111\u1ebfm s\u1ed1 \u00f4 trong ph\u1ea1m vi ch\u1ec9 \u0111\u1ecbnh \u0111\u00e1p \u1ee9ng m\u1ed9t ti\u00eau ch\u00ed duy nh\u1ea5t.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Lam_noi_bat_du_lieu_trung_lap_bao_gom_lan_dau_xuat_hien\"><\/span><strong>L\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p bao \u00a0g\u1ed3m\u00a0l\u1ea7n \u0111\u1ea7u xu\u1ea5t hi\u1ec7n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\"><strong>=COUNTIF($A$2:$A$10,$A2)&gt;1<\/strong>\u00a0\u2013 c\u00f4ng th\u1ee9c n\u00e0y t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong C\u1ed9t A (A2: A10 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y), bao g\u1ed3m c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u1ecdn \u00e1p d\u1ee5ng quy t\u1eafc cho to\u00e0n b\u1ed9 b\u1ea3ng, to\u00e0n b\u1ed9 h\u00e0ng s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng, nh\u01b0 b\u1ea1n th\u1ea5y trong d\u01b0\u1edbi \u0111\u00e2y.\u00a0T\u00f4i \u0111\u00e3 quy\u1ebft \u0111\u1ecbnh thay \u0111\u1ed5i m\u00e0u ph\u00f4ng ch\u1eef.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/formula-highlight-duplicates.png\" alt=\"Excel formula to highlight duplicates including 1st occurrences\" title=\"formula-highlight-duplicates\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_noi_bat_du_lieu_trung_lap_khong_bao_gom_lan_dau_xuat_hien\"><\/span><strong>L\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p kh\u00f4ng bao \u00a0g\u1ed3m\u00a0l\u1ea7n \u0111\u1ea7u xu\u1ea5t hi\u1ec7n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">\u0110\u1ec3 b\u1ecf qua l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean v\u00e0 ch\u1ec9 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p ti\u1ebfp theo, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:\u00a0<strong>=COUNTIF($A$2:$A2,$A2)&gt;1<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/duplicates-without-first-occurrences.png\" alt=\"Excel formula to highlight duplicates without 1st occurrences\" title=\"duplicates-without-first-occurrences\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_noi_bat_cac_du_lieu_trung_lien_tiep_trong_Excel\"><\/span><strong>L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng li\u00ean ti\u1ebfp trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p tr\u00ean c\u00e1c h\u00e0ng li\u00ean ti\u1ebfp, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y theo c\u00e1ch sau.\u00a0Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y ho\u1ea1t \u0111\u1ed9ng cho b\u1ea5t k\u1ef3 lo\u1ea1i d\u1eef li\u1ec7u n\u00e0o: s\u1ed1, gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u00e0 ng\u00e0y th\u00e1ng.<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c b\u1ea3n sao,\u00a0<strong>kh\u00f4ng ch\u1ecdn ti\u00eau \u0111\u1ec1 c\u1ed9t<\/strong>\u00a0.<\/li>\n<li>T\u1ea1o m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n sau:<br \/>\nQuy t\u1eafc 1 (xanh d\u01b0\u01a1ng):\u00a0<strong>=$A1=$A2<\/strong>\u2013 n\u00eau b\u1eadt l\u1ea7n hai\u00a0v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n ti\u1ebfp theo, n\u1ebfu c\u00f3.<\/li>\n<li>Quy t\u1eafc 2 (xanh l\u00e1 c\u00e2y):\u00a0<strong>=$A2=$A3<\/strong>\u2013 l\u00e0m n\u1ed5i b\u1eadt l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u ti\u00ean\u00a0.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, A l\u00e0 c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra, $ A1 l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ed9t, $ A2 l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean v\u1edbi d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\"><strong>Quan tr\u1ecdng!\u00a0<\/strong>\u0110\u1ec3 c\u00e1c c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, \u0111i\u1ec1u quan tr\u1ecdng l\u00e0 Quy t\u1eafc 1 l\u00e0m n\u1ed5i b\u1eadt l\u1ea7n l\u1eb7p l\u1ea1i th\u1ee9 2\u00a0v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c l\u1ea7n l\u1eb7p l\u1ea1i ti\u1ebfp theo n\u00ean l\u00e0 quy t\u1eafc \u0111\u1ea7u ti\u00ean trong danh s\u00e1ch, \u0111\u1eb7c bi\u1ec7t n\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng hai m\u00e0u kh\u00e1c nhau.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/highlight-consecutive-duplicates.png\" alt=\"Highlighting consecutive duplicates in Excel\" title=\"highlight-consecutive-duplicates\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Danh_dau_cac_hang_trung\"><\/span><strong>\u0110\u00e1nh d\u1ea5u c\u00e1c h\u00e0ng tr\u00f9ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n khi gi\u00e1 tr\u1ecb tr\u00f9ng x\u1ea3y ra trong hai c\u1ed9t tr\u1edf l\u00ean, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i th\u00eam m\u1ed9t c\u1ed9t ph\u1ee5 v\u00e0o b\u1ea3ng c\u1ee7a m\u00ecnh, trong \u0111\u00f3 b\u1ea1n n\u1ed1i c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb c\u00e1c c\u1ed9t ch\u00ednh b\u1eb1ng m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n nh\u01b0 th\u1ebf n\u00e0y\u00a0<strong>=A2&amp;B2<\/strong>.\u00a0Sau \u0111\u00f3 b\u1ea1n \u00e1p d\u1ee5ng m\u1ed9t quy t\u1eafc b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng bi\u1ebfn th\u1ec3 c\u1ee7a c\u00f4ng th\u1ee9c COUNTIF cho c\u00e1c ph\u1ea7n l\u1eb7p (c\u00f3 ho\u1eb7c kh\u00f4ng x\u1ea3y ra l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 nh\u1ea5t).\u00a0\u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 \u1ea9n c\u1ed9t b\u1ed5 sung sau khi t\u1ea1o quy t\u1eafc.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6116\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-131.png\" width=\"600\" height=\"513\" title=\"excel-dialog-box-launcher-1-131\"><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0h\u00e0m COUNTIFS\u00a0nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c.\u00a0Trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, b\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n c\u1ed9t tr\u1ee3 gi\u00fap.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p\u00a0<strong>v\u1edbi l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean<\/strong>\u00a0, h\u00e3y t\u1ea1o ra m\u1ed9t quy t\u1eafc v\u1edbi c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS($A$2:$A$11, $A2, $B$2:$B$11, $B2)&gt;1<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p\u00a0<strong>m\u00e0 kh\u00f4ng c\u00f3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean<\/strong>\u00a0, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS($A$2:$A2, $A2, $B$2:$B2, $B2)&gt;1<\/strong><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"So_sanh_hai_cot_trung_lap\"><\/span><strong>So s\u00e1nh <\/strong><strong>hai<\/strong><strong> c\u1ed9t <\/strong><strong>tr\u00f9ng l\u1eb7p<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">M\u1ed9t trong nh\u1eefng nhi\u1ec7m v\u1ee5 th\u01b0\u1eddng g\u1eb7p nh\u1ea5t trong Excel l\u00e0 ki\u1ec3m tra 2 c\u1ed9t cho c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p \u2013 t\u1ee9c l\u00e0 t\u00ecm v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb t\u1ed3n t\u1ea1i trong c\u1ea3 hai c\u1ed9t.\u00a0\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i t\u1ea1o ra m\u1ed9t quy t\u1eafc Excel \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho m\u1ed7i c\u1ed9t v\u1edbi s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a h\u00e0m \u00a0<strong>=ISERROR()<\/strong>v\u00e0\u00a0<strong>=MATCH()<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi C\u1ed9t A:\u00a0<strong>=ISERROR(MATCH(A1,$B$1:$B$10000,0))=FALSE<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi C\u1ed9t B:\u00a0<strong>=ISERROR(MATCH(B1,$A$1:$A$10000,0))=FALSE<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa th\u00edch.\u00a0<\/strong>\u0110\u1ec3 c\u00e1c c\u00f4ng th\u1ee9c c\u00f3 \u0111i\u1ec1u ki\u1ec7n nh\u01b0 v\u1eady ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, \u0111i\u1ec1u r\u1ea5t quan tr\u1ecdng l\u00e0 b\u1ea1n \u00e1p d\u1ee5ng c\u00e1c quy t\u1eafc cho to\u00e0n b\u1ed9 c\u00e1c c\u1ed9t, v\u00ed d\u1ee5\u00a0<strong>=$A:$A<\/strong>v\u00e0\u00a0<strong>=$B:$B<\/strong>.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 xem v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng th\u1ef1c t\u1ebf trong h\u00ecnh sau \u0111\u00e2y \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c c\u1ed9t tr\u00f9ng l\u1eb7p trong C\u1ed9t E v\u00e0 F.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6117\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-132.png\" width=\"600\" height=\"489\" title=\"excel-dialog-box-launcher-1-132\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_de_lam_noi_bat_cac_gia_tri_o_tren_hoac_duoi_trung_binh\"><\/span><strong>C\u00f4ng th\u1ee9c \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb \u1edf tr\u00ean ho\u1eb7c d\u01b0\u1edbi trung b\u00ecnh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u s\u1ed1,\u00a0h\u00e0m\u00a0<em>AVERAGE ()<\/em>\u00a0c\u00f3 th\u1ec3 c\u00f3 \u00edch \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb th\u1ea5p h\u01a1n ho\u1eb7c cao h\u01a1n m\u1ee9c trung b\u00ecnh trong m\u1ed9t c\u1ed9t.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\u00a0<strong>=$E2&lt;AVERAGE($E$2:$E$8) <\/strong>\u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00e1c h\u00e0ng c\u00f3 s\u1ed1 b\u00e1n th\u1ea5p h\u01a1n m\u1ee9c trung b\u00ecnh, nh\u01b0 th\u1ec3 hi\u1ec7n trong h\u00ecnh b\u00ean d\u01b0\u1edbi.\u00a0N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm \u0111i\u1ec1u ng\u01b0\u1ee3c l\u1ea1i, t\u1ee9c l\u00e0 \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c s\u1ea3n ph\u1ea9m th\u1ef1c hi\u1ec7n tr\u00ean m\u1ee9c trung b\u00ecnh, thay th\u1ebf \u201c&lt;\u201d b\u1eb1ng \u201c&gt;\u201d trong c\u00f4ng th\u1ee9c:\u00a0<strong>=$E2&gt;AVERAGE($E$2:$E$8)<\/strong>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6118\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-133.png\" width=\"600\" height=\"169\" title=\"excel-dialog-box-launcher-1-133\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_lam_noi_bat_gia_tri_gan_nhat_trong_Excel\"><\/span><strong>C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 1. T\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t, bao g\u1ed3m k\u1ebft h\u1ee3p ch\u00ednh x\u00e1c<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta, ch\u00fang ta s\u1ebd t\u00ecm v\u00e0 \u0111\u00e1nh d\u1ea5u s\u1ed1 g\u1ea7n nh\u1ea5t v\u1edbi s\u1ed1 kh\u00f4ng.\u00a0N\u1ebfu t\u1eadp d\u1eef li\u1ec7u ch\u1ee9a m\u1ed9t ho\u1eb7c nhi\u1ec1u s\u1ed1 kh\u00f4ng, t\u1ea5t c\u1ea3 ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u.\u00a0N\u1ebfu kh\u00f4ng c\u00f3 0, th\u00ec gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t v\u1edbi n\u00f3, d\u01b0\u01a1ng ho\u1eb7c \u00e2m, s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u.<\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc h\u1ebft, b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o b\u1ea5t k\u1ef3 \u00f4 tr\u1ed1ng n\u00e0o trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n, b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 \u1ea9n \u00f4 \u0111\u00f3 sau, n\u1ebfu c\u1ea7n.\u00a0C\u00f4ng th\u1ee9c t\u00ecm th\u1ea5y s\u1ed1 trong m\u1ed9t d\u00e3y nh\u1ea5t \u0111\u1ecbnh g\u1ea7n nh\u1ea5t v\u1edbi s\u1ed1 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i c\u1ee7a s\u1ed1 \u0111\u00f3 (gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i l\u00e0 s\u1ed1 kh\u00f4ng c\u00f3 d\u1ea5u \u00e2m):<\/p>\n<p style=\"text-align: justify\"><strong>=MIN(ABS(B2:D13-(0)))<\/strong><\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c tr\u00ean, B2: D13 l\u00e0 d\u1ea3i \u00f4 c\u1ee7a b\u1ea1n v\u00e0 0 l\u00e0 s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm k\u1ebft h\u1ee3p g\u1ea7n nh\u1ea5t.\u00a0V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t v\u1edbi 5, c\u00f4ng th\u1ee9c s\u1ebd thay \u0111\u1ed5i th\u00e0nh:<strong>=MIN(ABS(B2:D13-(5)))<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa th\u00edch.\u00a0<\/strong>\u0110\u00e2y l\u00e0 m\u1ed9t\u00a0<strong>c\u00f4ng th\u1ee9c m\u1ea3ng<\/strong>\u00a0, v\u00ec v\u1eady b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1ea5n\u00a0Ctrl + Shift + Enter\u00a0thay v\u00ec g\u00f5 Enter \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 ho\u00e0n th\u00e0nh n\u00f3.<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, b\u1ea1n t\u1ea1o m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u1edbi c\u00f4ng th\u1ee9c sau, trong \u0111\u00f3 B3 l\u00e0 \u00f4 tr\u00ean c\u00f9ng b\u00ean ph\u1ea3i trong ph\u1ea1m vi c\u1ee7a b\u1ea1n v\u00e0 $ C $ 2 trong \u00f4 b\u1eb1ng c\u00f4ng th\u1ee9c m\u1ea3ng tr\u00ean:<\/p>\n<p style=\"text-align: justify\"><strong>=OR(B3=0-$C$2,B3=0+$C$2)<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e3y ch\u00fa \u00fd \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i trong \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c m\u1ea3ng ($C$2), b\u1edfi v\u00ec \u00f4 n\u00e0y l\u00e0 h\u1eb1ng s\u1ed1.\u00a0Ngo\u00e0i ra, b\u1ea1n c\u1ea7n ph\u1ea3i thay th\u1ebf 0 b\u1eb1ng s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt k\u1ebft h\u1ee3p g\u1ea7n nh\u1ea5t.\u00a0V\u00ed d\u1ee5: n\u1ebfu ch\u00fang ta mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t \u0111\u1ebfn 5, c\u00f4ng th\u1ee9c s\u1ebd thay \u0111\u1ed5i th\u00e0nh:<strong>=OR(B3=5-$C$2,B3=5+$C$2)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6119\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-134.png\" width=\"600\" height=\"364\" title=\"excel-dialog-box-launcher-1-134\"><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 2. L\u00e0m n\u1ed5i b\u1eadt m\u1ed9t gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t v\u1edbi gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh, nh\u01b0ng kh\u00f4ng kh\u1edbp ho\u00e0n to\u00e0n<\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt m\u1ed9t k\u1ebft h\u1ee3p ch\u00ednh x\u00e1c, b\u1ea1n c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng kh\u00e1c nhau s\u1ebd t\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t nh\u01b0ng b\u1ecf qua k\u1ebft h\u1ee3p ch\u00ednh x\u00e1c.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c m\u1ea3ng sau t\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n v\u1edbi 0 nh\u1ea5t trong ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, nh\u01b0ng b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng, n\u1ebfu c\u00f3:<\/p>\n<p style=\"text-align: justify\"><strong>=MIN(ABS(B3:C13-(0))+(10^0*(B3:C13=0)))<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb nh\u1ea5n\u00a0Ctrl + Shift + Enter\u00a0sau khi b\u1ea1n g\u00f5 xong c\u00f4ng th\u1ee9c m\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n gi\u1ed1ng nh\u01b0 trong v\u00ed d\u1ee5 tr\u00ean:<\/p>\n<p style=\"text-align: justify\"><strong>=OR(B3=0-$C$2,B3=0+$C$2)<\/strong><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, v\u00ec c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ee7a ch\u00fang ta trong \u00f4 C2 b\u1ecf qua k\u1ebft h\u1ee3p ch\u00ednh x\u00e1c, quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n s\u1ebd b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng v\u00e0 l\u00e0m n\u1ed5i b\u1eadt gi\u00e1 tr\u1ecb 0.003 l\u00e0 k\u1ebft h\u1ee3p g\u1ea7n nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6120\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-135.png\" width=\"600\" height=\"399\" title=\"excel-dialog-box-launcher-1-135\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t v\u1edbi m\u1ed9t s\u1ed1 kh\u00e1c trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n, ch\u1ec9 c\u1ea7n thay th\u1ebf \u201c0\u201d b\u1eb1ng s\u1ed1 b\u1ea1n mu\u1ed1n c\u1ea3 trong m\u1ea3ng v\u00e0 c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tai_sao_dinh_dang_co_dieu_kien_Excel_cua_toi_khong_hoat_dong_dung\"><\/span><strong>T\u1ea1i sao \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Excel c\u1ee7a t\u00f4i kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng nh\u01b0 mong \u0111\u1ee3i, m\u1eb7c d\u00f9 c\u00f4ng th\u1ee9c d\u01b0\u1eddng nh\u01b0 \u0111\u00fang, \u0111\u1eebng bu\u1ed3n b\u00e3!\u00a0R\u1ea5t c\u00f3 th\u1ec3 n\u00f3 kh\u00f4ng ph\u1ea3i l\u00e0 do m\u1ed9t s\u1ed1 l\u1ed7i l\u1ea1 trong Excel, m\u00e0 v\u00ec do m\u1ed9t sai l\u1ea7m nh\u1ecf, kh\u00f4ng nh\u1eadn ra ngay \u0111\u01b0\u1ee3c.\u00a0Vui l\u00f2ng th\u1eed 6 b\u01b0\u1edbc kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y v\u00e0 t\u00f4i ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c c\u1ee7a m\u00ecnh \u0111\u1ec3 l\u00e0m vi\u1ec7c:<\/p>\n<ol style=\"text-align: justify\">\n<li><strong>S\u1eed d\u1ee5ng c\u00e1c \u0111\u1ecba ch\u1ec9 \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i ch\u00ednh x\u00e1c.\u00a0<\/strong>R\u1ea5t kh\u00f3 \u0111\u1ec3 c\u00f3 th\u1ec3 suy ra m\u1ed9t nguy\u00ean t\u1eafc chung s\u1ebd ho\u1ea1t \u0111\u1ed9ng trong 100% tr\u01b0\u1eddng h\u1ee3p.\u00a0Nh\u01b0ng th\u01b0\u1eddng th\u00ec b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng m\u1ed9t c\u1ed9t tuy\u1ec7t \u0111\u1ed1i (v\u1edbi $) v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 $) trong c\u00e1c tham chi\u1ebfu \u00f4 c\u1ee7a b\u1ea1n, v\u00ed d\u1ee5\u00a0<strong>=$A1&gt;1<\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb r\u1eb1ng c\u00e1c c\u00f4ng th\u1ee9c\u00a0<strong>=A1=1<\/strong>,\u00a0<strong>=$A$1=1<\/strong>v\u00e0\u00a0<strong>=A$1=1\u00a0<\/strong>s\u1ebd cho k\u1ebft qu\u1ea3 kh\u00e1c nhau.\u00a0N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1eafc ch\u1eafn c\u00e1i n\u00e0o l\u00e0 \u0111\u00fang trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a b\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 th\u1eed t\u1ea5t c\u1ea3.<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li><strong>X\u00e1c minh ph\u1ea1m vi \u00e1p d\u1ee5ng.\u00a0<\/strong>Ki\u1ec3m tra xem quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n c\u00f3 \u00e1p d\u1ee5ng cho \u0111\u00fang ph\u1ea1m vi c\u1ee7a \u00f4.\u00a0M\u1ed9t quy t\u1eafc l\u00e0 \u2013 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \/ h\u00e0ng b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng nh\u01b0ng kh\u00f4ng bao g\u1ed3m c\u00e1c ti\u00eau \u0111\u1ec1 c\u1ed9t.<\/li>\n<li><strong>Vi\u1ebft c\u00f4ng th\u1ee9c cho \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i.\u00a0<\/strong>Trong c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, tham chi\u1ebfu \u00f4 li\u00ean quan \u0111\u1ebfn \u00f4 ph\u00eda tr\u00ean c\u00f9ng b\u00ean tr\u00e1i trong ph\u1ea1m vi \u00e1p d\u1ee5ng.\u00a0V\u00ec v\u1eady, lu\u00f4n lu\u00f4n vi\u1ebft c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n cho d\u00f2ng th\u1ee9 nh\u1ea5t v\u1edbi d\u1eef li\u1ec7u.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: n\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n b\u1eaft \u0111\u1ea7u \u1edf h\u00e0ng 2, b\u1ea1n g\u00f5\u00a0<strong>=A$2=10 <\/strong>s\u1ebd \u0111\u00e1nh d\u1ea5u c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 10 trong\u00a0<strong>t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng<\/strong>\u00a0.\u00a0M\u1ed9t sai l\u1ea7m ph\u1ed5 bi\u1ebfn l\u00e0 lu\u00f4n lu\u00f4n s\u1eed d\u1ee5ng m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn h\u00e0ng \u0111\u1ea7u ti\u00ean (v\u00ed d\u1ee5\u00a0<strong>=A$1=10<\/strong>).\u00a0H\u00e3y nh\u1edb r\u1eb1ng, b\u1ea1n tham kh\u1ea3o h\u00e0ng 1 trong c\u00f4ng th\u1ee9c ch\u1ec9 khi b\u1ea3ng c\u1ee7a b\u1ea1n kh\u00f4ng c\u00f3 ti\u00eau \u0111\u1ec1 v\u00e0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n th\u1ef1c s\u1ef1 b\u1eaft \u0111\u1ea7u trong h\u00e0ng 1. D\u1ea5u hi\u1ec7u r\u00f5 r\u00e0ng nh\u1ea5t c\u1ee7a tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 khi c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng, nh\u01b0ng c\u00e1c \u0111\u1ecbnh d\u1ea1ng gi\u00e1 tr\u1ecb kh\u00f4ng xu\u1ea5t hi\u1ec7n \u0111\u00fang n\u01a1i c\u1ea7n thi\u1ebft.<\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li><strong>Ki\u1ec3m tra quy t\u1eafc b\u1ea1n \u0111\u00e3 t\u1ea1o.\u00a0<\/strong>Ki\u1ec3m tra l\u1ea1i quy t\u1eafc trong Conditional Formatting Rules.\u00a0\u0110\u00f4i khi, kh\u00f4ng c\u00f3 l\u00fd do g\u00ec c\u1ea3, Microsoft Excel b\u00f3p m\u00e9o quy t\u1eafc b\u1ea1n v\u1eeba t\u1ea1o ra.\u00a0V\u00ec v\u1eady, n\u1ebfu quy t\u1eafc kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng, h\u00e3y chuy\u1ec3n \u0111\u1ebfn\u00a0<em>Conditional Formatting &gt; Manage Rules\u00a0<\/em>v\u00e0 ki\u1ec3m tra c\u1ea3 c\u00f4ng th\u1ee9c v\u00e0 ph\u1ea1m vi \u00e1p d\u1ee5ng.\u00a0N\u1ebfu b\u1ea1n \u0111\u00e3 sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb web ho\u1eb7c m\u1ed9t s\u1ed1 ngu\u1ed3n b\u00ean ngo\u00e0i kh\u00e1c, \u0111\u1ea3m b\u1ea3o\u00a0s\u1eed d\u1ee5ng\u00a0<strong>d\u1ea5u nh\u00e1y<\/strong>\u00a0.<\/li>\n<li><strong>\u0110i\u1ec1u ch\u1ec9nh c\u00e1c tham chi\u1ebfu \u00f4 khi sao ch\u00e9p quy t\u1eafc.\u00a0<\/strong>N\u1ebfu b\u1ea1n\u00a0sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Excel\u00a0b\u1eb1ng Format Painter, \u0111\u1eebng qu\u00ean \u0111i\u1ec1u ch\u1ec9nh t\u1ea5t c\u1ea3 c\u00e1c tham chi\u1ebfu \u00f4 trong c\u00f4ng th\u1ee9c.<\/li>\n<li><strong>Chia c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p th\u00e0nh c\u00e1c ph\u1ea7n t\u1eed \u0111\u01a1n gi\u1ea3n.\u00a0<\/strong>N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c Excel ph\u1ee9c t\u1ea1p bao g\u1ed3m m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c nhau, chia th\u00e0nh c\u00e1c ph\u1ea7n t\u1eed \u0111\u01a1n gi\u1ea3n v\u00e0 x\u00e1c minh t\u1eebng h\u00e0m m\u1ed9t.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">V\u00e0 cu\u1ed1i c\u00f9ng, n\u1ebfu b\u1ea1n \u0111\u00e3 th\u1eed t\u1ea5t c\u1ea3 c\u00e1c b\u01b0\u1edbc nh\u01b0ng quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n v\u1eabn kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, h\u00e3y vi\u1ebft cho t\u00f4i m\u1ed9t d\u00f2ng trong nh\u1eadn x\u00e9t v\u00e0 ch\u00fang ta s\u1ebd c\u1ed1 g\u1eafng t\u00ecm hi\u1ec3u n\u00f3 c\u00f9ng nhau \ud83d\ude42<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026 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=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. 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\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/a><\/p>\n<p><em><strong>Ngu\u1ed3<\/strong><\/em><em><strong>n:<\/strong><\/em><em>\u00a0Ablebits, d\u1ecb<\/em><em>ch v\u00e0 bi\u00ean t\u1ead<\/em><em>p b\u1edf<\/em><em>i <a href=\"http:\/\/blog.ezworkapp.com\">blog.hocexcel.online<\/a><\/em><\/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-111.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3338,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3337","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\/3337","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=3337"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3337\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3338"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}