{"id":7518,"date":"2024-12-21T17:53:16","date_gmt":"2024-12-21T17:53:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-xoa-bo-dinh-dang-theo-dieu-kien-conditional-formatting-trong-excel\/"},"modified":"2024-12-21T17:53:16","modified_gmt":"2024-12-21T17:53:16","slug":"huong-dan-cach-xoa-bo-dinh-dang-theo-dieu-kien-conditional-formatting-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-xoa-bo-dinh-dang-theo-dieu-kien-conditional-formatting-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00f3a b\u1ecf \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n Conditional formatting trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-dinh-dang-co-dieu-kien-trong-excel-2010-2013-va-2016.html\">Conditional Formatting<\/a><\/strong>\u00a0l\u00e0 t\u00ednh n\u0103ng thi\u1ebft l\u1eadp\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n\u00a0trong\u00a0Excel. T\u00ednh n\u0103ng n\u00e0y r\u1ea5t h\u1eefu\u00a0\u00edch v\u00e0 \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi \u01b0a th\u00edch s\u1eed d\u1ee5ng. B\u1edfi n\u00f3 gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng c\u1ea3nh b\u00e1o nh\u1eefng n\u1ed9i dung \u0111\u1eb7c bi\u1ec7t: d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p,\u00a0m\u1ed9t gi\u00e1 tr\u1ecb n\u1eb1m ngo\u00e0i ph\u1ea1m vi gi\u1edbi h\u1ea1n, hay\u00a0\u0111\u1ebfn ng\u00e0y h\u1ebft h\u1ea1n c\u1ee7a h\u1ee3p\u00a0\u0111\u1ed3ng\u2026<\/em><\/p>\n<p>Tuy nhi\u00ean n\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft v\u1ec1 t\u00ednh n\u0103ng n\u00e0y th\u00ec s\u1ebd g\u1eb7p m\u1ed9t ch\u00fat r\u1eafc r\u1ed1i khi b\u1ea1n kh\u00f4ng th\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng n\u00e0y b\u1eb1ng Format cells th\u00f4ng th\u01b0\u1eddng. \u0110\u00f4i khi b\u1ea1n kh\u00f4ng r\u00f5 \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 thi\u1ebft l\u1eadp l\u00e0 g\u00ec, d\u1eabn t\u1edbi nh\u1eefng \u0111\u1ecbnh d\u1ea1ng t\u1ef1 \u0111\u1ed9ng n\u00e0y kh\u00f4ng \u0111\u00fang theo \u00fd mu\u1ed1n. Khi \u0111\u00f3 b\u1ea1n c\u1ea7n x\u00f3a b\u1ecf \u0111\u1ecbnh d\u1ea1ng n\u00e0y \u0111i, ho\u1eb7c thi\u1ebft l\u1eadp l\u1ea1i. Vi\u1ec7c n\u00e0y l\u00e0m nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a>\u00a0t\u00ecm hi\u1ec3u v\u1ec1 n\u1ed9i dung n\u00e0y nh\u00e9.<\/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-6767008ba5268\" 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-xoa-bo-dinh-dang-theo-dieu-kien-conditional-formatting-trong-excel.html#Nguyen_nhan_gay_ra_Conditional_formatting_ngoai_y_muon\" title=\"Nguy\u00ean nh\u00e2n g\u00e2y ra\u00a0Conditional formatting ngo\u00e0i\u00a0\u00fd mu\u1ed1n\">Nguy\u00ean nh\u00e2n g\u00e2y ra\u00a0Conditional formatting ngo\u00e0i\u00a0\u00fd mu\u1ed1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xoa-bo-dinh-dang-theo-dieu-kien-conditional-formatting-trong-excel.html#Cach_xoa_bo_Conditional_formatting\" title=\"C\u00e1ch x\u00f3a b\u1ecf Conditional formatting\">C\u00e1ch x\u00f3a b\u1ecf Conditional formatting<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xoa-bo-dinh-dang-theo-dieu-kien-conditional-formatting-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nguyen_nhan_gay_ra_Conditional_formatting_ngoai_y_muon\"><\/span>Nguy\u00ean nh\u00e2n g\u00e2y ra\u00a0Conditional formatting ngo\u00e0i\u00a0\u00fd mu\u1ed1n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u1ea1i sao b\u1ea1n kh\u00f4ng h\u1ec1 thi\u1ebft l\u1eadp g\u00ec nh\u01b0ng l\u1ea1i c\u00f3 Conditional formatting trong b\u1ea3ng t\u00ednh?\u00a0Nguy\u00ean nh\u00e2n ch\u1ee7 y\u1ebfu c\u1ee7a vi\u1ec7c n\u00e0y l\u00e0 do b\u1ea1n\u00a0\u0111\u00e3\u00a0<strong>Copy 1 v\u00f9ng d\u1eef li\u1ec7u\u00a0\u0111ang\u00a0\u00e1p d\u1ee5ng Conditional formatting<\/strong>. Sau\u00a0\u0111\u00f3 l\u1ea1i d\u00e1n tr\u1ef1c ti\u1ebfp to\u00e0n b\u1ed9 nh\u1eefng g\u00ec\u00a0\u0111\u00e3 copy sang v\u1ecb tr\u00ed m\u1edbi. Khi\u00a0\u0111\u00f3 v\u1ecb tr\u00ed m\u1edbi c\u0169ng s\u1ebd mang theo thi\u1ebft l\u1eadp Conditional formatting. Trong m\u1ed9t s\u1ed1\u00a0tr\u01b0\u1eddng h\u1ee3p vi\u1ec7c copy\/paste n\u00e0y l\u00e0m n\u1ed9i dung thi\u1ebft l\u1eadp b\u00ean trong Conditional formatting b\u1ecb\u00a0<strong>thay\u00a0\u0111\u1ed5i<\/strong>, d\u1eabn t\u1edbi\u00a0vi\u1ec7c\u00a0\u0111\u1ecbnh d\u1ea1ng l\u1ed9n x\u1ed9n, kh\u00f4ng\u00a0\u0111\u00fang nh\u01b0 mong mu\u1ed1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_xoa_bo_Conditional_formatting\"><\/span>C\u00e1ch x\u00f3a b\u1ecf Conditional formatting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>C\u00e1ch 1: B\u1ea1n x\u00f3a tr\u1ef1c ti\u1ebfp t\u1ea1i m\u1ee5c Clear Rules c\u1ee7a Conditional formatting<\/strong><\/p>\n<p>Khi th\u1ef1c hi\u1ec7n c\u00e1ch n\u00e0y, b\u1ea1n C\u00f3 th\u1ec3 l\u00e0m theo 2 ph\u01b0\u01a1ng ph\u00e1p:<\/p>\n<ul>\n<li>Th\u1ee9 1:\u00a0ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u\u00a0c\u1ea7n x\u00f3a conditional formatting tr\u01b0\u1edbc, sau\u00a0\u0111\u00f3 b\u1ea5m ch\u1ecdn m\u1ee5c <strong>Clear Rules from Select Cells\u00a0<\/strong>(x\u00f3a to\u00e0n b\u1ed9 thi\u1ebft l\u1eadp trong v\u00f9ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn)<\/li>\n<li>Th\u1ee9 2: x\u00f3a t\u1ea5t c\u1ea3 Conditional f\u1ecfrmatting trong to\u00e0n b\u1ed9 Sheet b\u1eb1ng c\u00e1ch ch\u1ecdn<strong> Clear Rules from Entire Sheet<\/strong> (X\u00f3a to\u00e0n b\u1ed9 thi\u1ebft l\u1eadp trong Sheet hi\u1ec7n t\u1ea1i)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30850 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/conditional-formatting-clear-rule.png\" alt=\"bo-dinh-dang-conditional-format-trong-excel-1\" width=\"533\" height=\"595\" title=\"conditional-formatting-clear-rule\"><\/p>\n<p><strong>C\u00e1ch 2: X\u00f3a l\u1ea7n l\u01b0\u1ee3t t\u1eebng Rules trong Manage Rules<\/strong><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-674.gif\" title=\"ex101_92019-nho-674\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>V\u1edbi c\u00e1ch n\u00e0y, b\u1ea1n ch\u1ecdn m\u1ee5c Manage Rules, trong c\u1eeda s\u1ed5 Manage Rules, b\u1ea1n s\u1ebd ch\u1ecdn t\u1eebng\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n x\u00f3a r\u1ed3i b\u1ea5m ch\u1ecdn Delete<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30851 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/manage-rules-delete.png\" alt=\"bo-dinh-dang-conditional-format-trong-excel-2\" width=\"778\" height=\"378\" title=\"manage-rules-delete\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u1ec7c m\u1eafc ph\u1ea3i l\u1ed7i tr\u00ean l\u00e0 do b\u1ea1n c\u00f2n ch\u01b0a bi\u1ebft v\u1ec1 c\u00e1c c\u00f4ng c\u1ee5 tr\u00ean Excel th\u01b0\u1eddng s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c.\u00a0\u0110i\u1ec1u n\u00e0y d\u1eabn t\u1edbi nh\u1eefng kh\u00f3 kh\u0103n khi l\u00e0m vi\u1ec7c: l\u00e0m vi\u1ec7c ch\u1eadm h\u01a1n, hay g\u1eb7p l\u1ed7i, ph\u1ea3i t\u00ecm c\u00e1ch s\u1eeda\u2026 m\u00e0 kh\u00f4ng c\u00f3 t\u00ednh ch\u1ee7\u00a0\u0111\u1ed9ng. Do\u00a0\u0111\u00f3 b\u1ea1n n\u00ean trang b\u1ecb cho m\u00ecnh nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1\u00a0Excel m\u1ed9t c\u00e1ch\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7, h\u1ec7 th\u1ed1ng\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ef1 tin v\u00e0 ch\u1ee7\u00a0\u0111\u1ed9ng h\u01a1n trong c\u00f4ng vi\u1ec7c.<\/p>\n<p>Nh\u1eb1m gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7n th\u1eddi gian, c\u00f4ng s\u1ee9c v\u00e0 chi ph\u00ed cho vi\u1ec7c h\u1ecdc Excel, ch\u00fang t\u00f4i xin gi\u1edbi thi\u1ec7u v\u1edbi b\u1ea1n <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\"><strong>kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/strong> <\/a>d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m.\u00a0Gi\u1ea3ng vi\u00ean c\u1ee7a kh\u00f3a h\u1ecdc n\u00e0y l\u00e0 th\u1ea7y Nguy\u1ec5n\u00a0\u0110\u1ee9c Thanh \u2013 gi\u1ea3ng vi\u00ean v\u1ec1 tin h\u1ecdc v\u0103n ph\u00f2ng uy t\u00edn nh\u1ea5t t\u1ea1i Vi\u1ec7t Nam. V\u1edbi n\u1ed9i dung chi ti\u1ebft,\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7, d\u1ec5 hi\u1ec3u, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 y\u00ean t\u00e2m v\u1ec1 ki\u1ebfn th\u1ee9c s\u1ebd c\u00f3\u00a0\u0111\u01b0\u1ee3c khi tham gia h\u1ecdc kh\u00f3a h\u1ecdc n\u00e0y. Ngo\u00e0i ra b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 h\u1ecdc c\u00f9ng v\u1edbi h\u00e0ng ngh\u00ecn h\u1ecdc vi\u00ean kh\u00e1c trong kh\u00f3a h\u1ecdc n\u00e0y, tham kh\u1ea3o nh\u1eefng v\u00ed d\u1ee5 th\u1ef1c t\u1ebf th\u00f4ng qua vi\u1ec7c th\u1ea3o lu\u1eadn c\u00f9ng gi\u1ea3ng vi\u00ean. Nh\u1eefng\u00a0\u0111i\u1ec1u n\u00e0y r\u1ea5t b\u1ed5\u00a0\u00edch, gi\u00fap b\u1ea1n v\u1eeba h\u1ecdc, v\u1eeba v\u1eadn d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c ki\u1ebfn th\u1ee9c v\u00e0o trong c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-674.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7519,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7518","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7518","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=7518"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7518\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7519"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}