{"id":3372,"date":"2024-12-03T02:18:35","date_gmt":"2024-12-03T02:18:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-su-dung-dinh-dang-co-dieu-kien-trong-excel-2010-2013-va-2016\/"},"modified":"2024-12-03T02:18:35","modified_gmt":"2024-12-03T02:18:35","slug":"cach-su-dung-dinh-dang-co-dieu-kien-trong-excel-2010-2013-va-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-su-dung-dinh-dang-co-dieu-kien-trong-excel-2010-2013-va-2016\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel 2010, 2013 v\u00e0 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1c t\u00ednh n\u0103ng c\u01a1 b\u1ea3n c\u1ee7a \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.\u00a0B\u1ea1n s\u1ebd h\u1ecdc c\u00e1ch t\u1ea1o c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau, c\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean m\u1ed9t \u00f4 kh\u00e1c, c\u00e1ch ch\u1ec9nh s\u1eeda v\u00e0 sao ch\u00e9p c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng trong Excel 2007, 2010 2013 v\u00e0 2016.<\/em><\/p>\n<p><strong>C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n v\u1ec1 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel<\/strong><\/p>\n<p>Gi\u1ed1ng nh\u01b0 \u0111\u1ecbnh d\u1ea1ng \u00f4 th\u00f4ng th\u01b0\u1eddng, b\u1ea1n s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u theo nhi\u1ec1u c\u00e1ch kh\u00e1c nhau: thay \u0111\u1ed5i m\u00e0u s\u1eafc, m\u00e0u font v\u00e0 c\u00e1c ki\u1ec3u \u0111\u01b0\u1eddng vi\u1ec1n \u00f4.\u00a0S\u1ef1 kh\u00e1c bi\u1ec7t l\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n linh ho\u1ea1t h\u01a1n, cho ph\u00e9p b\u1ea1n \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u khi \u0111\u00e1p \u1ee9ng c\u00e1c ti\u00eau ch\u00ed ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4, h\u00e0ng, c\u1ed9t ho\u1eb7c to\u00e0n b\u1ed9 b\u1ea3ng d\u1ef1a tr\u00ean n\u1ed9i dung \u00f4 ho\u1eb7c d\u1ef1a v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 kh\u00e1c b\u1eb1ng c\u00e1ch t\u1ea1o ra c\u00e1c quy t\u1eafc (\u0111i\u1ec1u ki\u1ec7n) x\u00e1c \u0111\u1ecbnh khi n\u00e0o v\u00e0 nh\u01b0 th\u1ebf n\u00e0o th\u00ec c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p><strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel \u1edf \u0111\u00e2u?<\/strong><\/p>\n<p>Trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n c\u1ee7a Excel, \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u1eb1m \u1edf c\u00f9ng m\u1ed9t v\u1ecb tr\u00ed, tr\u00ean\u00a0tab\u00a0<strong><em>Home <\/em><\/strong><strong><em>&gt;\u00a0Styles<\/em><\/strong>.<\/p>\n<p><em>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel 2007<\/em><\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Conditional formatting in Excel 2007\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/conditional-formatting-excel2007.png\" alt=\"Conditional formatting in Excel 2007\"><\/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-113.gif\" title=\"vba101_92019-nho-113\"><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-259.gif\" title=\"ex101_92019-nho-259\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><em>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel 2010<\/em><\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Conditional formatting in Excel 2010\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/conditional-formatting-excel2010.png\" alt=\"Conditional formatting in Excel 2010\"><\/p>\n<p><em>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel 2013<\/em><\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Conditional formatting in Excel 2013\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/conditional-formatting-excel2013.png\" alt=\"Conditional formatting in Excel 2013\"><\/p>\n<p><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/strong><\/p>\n<p>\u0110\u1ec3 t\u1eadn d\u1ee5ng c\u00e1c kh\u1ea3 n\u0103ng c\u1ee7a \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel, b\u1ea1n ph\u1ea3i h\u1ecdc c\u00e1ch t\u1ea1o ra c\u00e1c lo\u1ea1i quy t\u1eafc kh\u00e1c nhau.<\/p>\n<p>C\u00f3 hai \u0111i\u1ec1u quan tr\u1ecdng trong \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li>Nh\u1eefng \u00f4 n\u00e0o c\u1ea7n ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, v\u00e0<\/li>\n<li>C\u1ea7n \u0111\u00e1p \u1ee9ng nh\u1eefng \u0111i\u1ec1u ki\u1ec7n n\u00e0o.<\/li>\n<\/ul>\n<p>T\u00f4i s\u1ebd ch\u1ec9 cho b\u1ea1n c\u00e1ch \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel 2010 v\u00ec \u0111\u00e2y c\u00f3 v\u1ebb l\u00e0 phi\u00ean b\u1ea3n ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay.\u00a0Tuy nhi\u00ean, c\u00e1c t\u00f9y ch\u1ecdn v\u1ec1 c\u01a1 b\u1ea3n gi\u1ed1ng nhau trong Excel 2007 v\u00e0 2013, v\u00ec v\u1eady b\u1ea1n s\u1ebd kh\u00f4ng g\u1eb7p b\u1ea5t k\u1ef3 v\u1ea5n \u0111\u1ec1 n\u00e0o cho d\u00f9 c\u00f3 b\u1ea1n d\u00f9ng kh\u00e1c phi\u00ean b\u1ea3n.<\/p>\n<ol>\n<li>Ch\u1ecdn c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<\/ol>\n<p>V\u00ed d\u1ee5, t\u00f4i t\u1ea1o m\u1ed9t b\u1ea3ng nh\u1ecf li\u1ec7t k\u00ea gi\u00e1 d\u1ea7u th\u00f4 h\u00e0ng th\u00e1ng.\u00a0\u0110i\u1ec1u ch\u00fang ta mu\u1ed1n l\u00e0m l\u00e0 l\u00e0m n\u1ed5i b\u1eadt s\u1ef1 gi\u1ea3m gi\u00e1, ngh\u0129a l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 s\u1ed1 \u00e2m trong\u00a0c\u1ed9t\u00a0<em>Change<\/em>, v\u00ec v\u1eady ch\u00fang ta ch\u1ecdn c\u00e1c \u00f4 C2: C9.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Select the cells you want to format.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/conditional-formatting-source-data.png\" alt=\"Select the cells you want to format.\"><\/p>\n<ol start=\"2\">\n<li>Chuy\u1ec3n \u0111\u1ebfn\u00a0tab\u00a0<strong><em>Home<\/em><em>&gt;\u00a0Styles<\/em><\/strong><em>\u00a0 <\/em>v\u00e0 nh\u1ea5p v\u00e0o\u00a0<strong><em>Co<\/em><\/strong><strong><em>nditional Formatting<\/em><\/strong><strong>.<\/strong>\u00a0B\u1ea1n c\u0169ng s\u1ebd th\u1ea5y m\u1ed9t s\u1ed1 quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng kh\u00e1c, g\u1ed3m\u00a0 data bars,\u00a0color scales\u00a0and\u00a0icon sets.<\/li>\n<li>V\u00ec ch\u00fang ta ch\u1ec9 c\u1ea7n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho c\u00e1c s\u1ed1 nh\u1ecf h\u01a1n 0, ch\u00fang ta ch\u1ecdn\u00a0<strong><em>Highlight Cells Rules &gt; Less Than \u2026<\/em><\/strong><\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Choose Highlight Cells Rules &gt; Less Than...\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hightlight-cells-rules.png\" alt=\"Choose Highlight Cells Rules &gt; Less Than...\"><\/p>\n<blockquote>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Kho\u00e1 h\u1ecdc Excel c\u01a1 ba\u0309n<\/a><\/p>\n<\/blockquote>\n<p>T\u1ea5t nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c v\u1edbi b\u1ea5t k\u1ef3 lo\u1ea1i quy t\u1eafc n\u00e0o kh\u00e1c th\u00edch h\u1ee3p cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, ch\u1eb3ng h\u1ea1n nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/li>\n<li>\u0110\u00e1nh d\u1ea5u v\u0103n b\u1ea3n c\u00f3 ch\u1ee9a t\u1eeb ho\u1eb7c k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh<\/li>\n<li>L\u00e0m n\u1ed5i b\u1eadt c\u00e1c b\u1ea3n copy<\/li>\n<li>\u0110\u1ecbnh d\u1ea1ng c\u00e1c ng\u00e0y c\u1ee5 th\u1ec3<\/li>\n<\/ul>\n<ol start=\"4\">\n<li>Nh\u1eadp gi\u00e1 tr\u1ecb trong h\u1ed9p \u1edf ph\u1ea7n b\u00ean ph\u1ea3i c\u1ee7a c\u1eeda s\u1ed5 d\u01b0\u1edbi \u201c<strong><em>Format cells that are LESS THAN<\/em><\/strong>\u201c, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta g\u00f5 0. Ngay khi b\u1ea1n nh\u1eadp gi\u00e1 tr\u1ecb, Microsoft Excel s\u1ebd l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 trong d\u00e3y \u0111\u00e3 ch\u1ecdn \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n.<\/li>\n<li>Ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n t\u1eeb danh s\u00e1ch.\u00a0B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc ho\u1eb7c nh\u1ea5p v\u00e0o\u00a0<strong><em>Custom Format\u2026<\/em><\/strong>\u0111\u1ec3 thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ri\u00eang b\u1ea1n.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Select the format you want to apply.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format.png\" alt=\"Select the format you want to apply.\"><\/p>\n<ol start=\"6\">\n<li>Trong\u00a0c\u1eeda s\u1ed5\u00a0<strong><em>Format Cells<\/em><\/strong>, chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c\u00a0tab\u00a0<strong>Font<\/strong>,\u00a0<strong>Border<\/strong>\u00a0v\u00e0\u00a0<strong>Fill<\/strong>\u00a0\u0111\u1ec3 ch\u1ecdn ki\u1ec3u ph\u00f4ng ch\u1eef, ki\u1ec3u \u0111\u01b0\u1eddng vi\u1ec1n v\u00e0 m\u00e0u n\u1ec1n.\u00a0Tr\u00ean c\u00e1c\u00a0tab\u00a0<strong><em>Font\u00a0<\/em><\/strong>v\u00e0<em>\u00a0<strong>Fill<\/strong><\/em>, b\u1ea1n s\u1ebd th\u1ea5y ngay m\u1eabu xem tr\u01b0\u1edbc \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh c\u1ee7a m\u00ecnh.<\/li>\n<li>Khi ho\u00e0n th\u00e0nh, nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>OK<\/em>\u1edf cu\u1ed1i c\u1eeda s\u1ed5.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Choose the background color.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fill-color.png\" alt=\"Choose the background color.\"><strong>M\u1eb9o<\/strong><strong>:<\/strong><\/p>\n<ul>\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam nhi\u1ec1u m\u00e0u n\u1ec1n ho\u1eb7c ph\u00f4ng ch\u1eef h\u01a1n b\u1ea3ng m\u00e0u chu\u1ea9n, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat\u00a0<strong><em>More Colors \u2026<\/em><\/strong>tr\u00ean\u00a0tab\u00a0<strong><em>Fill<\/em><\/strong>\u00a0ho\u1eb7c\u00a0<strong><em>Font<\/em><\/strong>.<\/li>\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng m\u1ed9t\u00a0<strong>m\u00e0u n\u1ec1n gradient<\/strong>, h\u00e3y nh\u1ea5p\u00a0v\u00e0o<em> n\u00fat <strong>Fill Effects<\/strong> <\/em>tr\u00ean\u00a0tab\u00a0<strong><em>Fill <\/em><\/strong>v\u00e0 ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn mong mu\u1ed1n.<\/li>\n<li>Nh\u1ea5p\u00a0<em>OK<\/em>\u0111\u1ec3 \u0111\u00f3ng\u00a0c\u1eeda s\u1ed5\u00a0\u201c<strong><em>Less Than<\/em><\/strong><em>\u201c<\/em> v\u00e0 ki\u1ec3m tra xem vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00f3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng ch\u00ednh x\u00e1c cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n hay kh\u00f4ng.<\/li>\n<\/ul>\n<blockquote>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-excel\">Th\u1ee7 thu\u1eadt Excel n\u00e2ng cao<\/a><\/p>\n<\/blockquote>\n<p>Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi, quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1edbi t\u1ea1o c\u1ee7a ch\u00fang ta ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang \u2013 n\u00f3 \u0111\u1ed5 b\u00f3ng t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb \u00e2m.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"The newly created conditional formatting rule is applied.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/conditional-formatting-result.png\" alt=\"The newly created conditional formatting rule is applied.\"><\/p>\n<p><strong>T\u1ea1o m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Excel t\u1eeb \u0111\u1ea7u<\/strong><\/p>\n<p>N\u1ebfu kh\u00f4ng c\u00f3 quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng s\u1eb5n \u0111\u1ec3 s\u1eed d\u1ee5ng ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u c\u1ee7a b\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t quy t\u1eafc m\u1edbi t\u1eeb \u0111\u1ea7u.<\/p>\n<ol>\n<li>Ch\u1ecdn c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u00e0 nh\u1ea5p v\u00e0o\u00a0<strong><em>Conditional Formatting &gt; New Rule<\/em><\/strong><em>\u2026<\/em><\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Creating a new conditional formatting rule in Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/conditional-formatting-rule.png\" alt=\"Creating a new conditional formatting rule in Excel\"><\/p>\n<ol start=\"2\">\n<li>H\u1ed9p <strong><em>Rule New Formatting<\/em><\/strong>s\u1ebd m\u1edf ra v\u00e0 b\u1ea1n ch\u1ecdn ki\u1ec3u quy t\u1eafc c\u1ea7n thi\u1ebft.\u00a0V\u00ed d\u1ee5: \u201c<strong><em>Format only cells that contain<\/em><\/strong>\u201d v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng c\u00e1c gi\u00e1 tr\u1ecb n\u1eb1m\u00a0<strong>gi\u1eefa 60 v\u00e0 70<\/strong>.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/5-6.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7652\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-6.bmp\" width=\"600\" height=\"511\" title=\"5-6\"><\/a><br \/>\n3.Nh\u1ea5p v\u00e0o n\u00fat\u00a0<strong>Format <\/strong>v\u00e0 thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng c\u1ee7a b\u1ea1n ch\u00ednh x\u00e1c nh\u01b0 ch\u00fang ta \u0111\u00e3 l\u00e0m trong v\u00ed d\u1ee5 tr\u01b0\u1edbc.<\/p>\n<p>4.Nh\u1ea5p\u00a0<em>OK<\/em>\u00a0hai l\u1ea7n \u0111\u1ec3 \u0111\u00f3ng c\u00e1c c\u1eeda s\u1ed5 \u0111ang m\u1edf v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n \u0111\u00e3 xong.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"The values are conditionally formatted.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-formatted.png\" alt=\"The values are conditionally formatted.\"><\/p>\n<p><strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Excel d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a \u00f4<\/strong><\/p>\n<p>Trong c\u1ea3 hai v\u00ed d\u1ee5 tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 t\u1ea1o ra c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng c\u00e1ch nh\u1eadp c\u00e1c s\u1ed1.\u00a0Tuy nhi\u00ean, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, t\u1ed1t h\u01a1n n\u00ean c\u0103n c\u1ee9 v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng.\u00a0L\u1ee3i th\u1ebf c\u1ee7a c\u00e1ch n\u00e0y l\u00e0 b\u1ea5t k\u1ec3 gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 \u0111\u00f3 thay \u0111\u1ed5i nh\u01b0 th\u1ebf n\u00e0o trong t\u01b0\u01a1ng lai, \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh v\u00e0 ph\u1ea3n \u00e1nh s\u1ef1 thay \u0111\u1ed5i d\u1eef li\u1ec7u.<\/p>\n<p>H\u00e3y s\u1eed d\u1ee5ng v\u00ed d\u1ee5 \u201cOil price\u201d, nh\u01b0ng l\u1ea7n n\u00e0y l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 gi\u00e1 trong c\u1ed9t B l\u1edbn h\u01a1n gi\u00e1 c\u1ee7a th\u00e1ng hai.<\/p>\n<p>B\u1ea1n t\u1ea1o quy t\u1eafc theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1 b\u1eb1ng c\u00e1ch ch\u1ecdn <strong><em>Conditional formatting<\/em><\/strong><em>\u00a0&gt;\u00a0<strong>Highlight Cells Rules &gt; Greater Than\u2026..<\/strong>\u00a0<\/em>Nh\u01b0ng thay v\u00ec g\u00f5 m\u1ed9t s\u1ed1 trong b\u01b0\u1edbc 4, b\u1ea1n ch\u1ecdn \u00f4 B6 b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng ch\u1ecdn ph\u1ea1m vi nh\u01b0 b\u1ea1n th\u01b0\u1eddng l\u00e0m trong Excel.\u00a0Do \u0111\u00f3, gi\u00e1 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/6-4.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7653\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-4.bmp\" width=\"600\" height=\"188\" title=\"6-4\"><\/a><\/p>\n<p><strong>\u00c1p d\u1ee5ng m\u1ed9t s\u1ed1 quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho m\u1ed9t \u00f4\/b\u1ea3ng<\/strong><\/p>\n<p>Khi s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel, b\u1ea1n kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n \u1edf m\u1ed9t quy t\u1eafc cho m\u1ed7i \u00f4.\u00a0B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng nhi\u1ec1u quy t\u1eafc logic m\u00e0 c\u00f4ng vi\u1ec7c c\u1ee5 th\u1ec3 c\u1ee7a b\u1ea1n y\u00eau c\u1ea7u.<\/p>\n<p>V\u00ed d\u1ee5, h\u00e3y t\u1ea1o ra 3 quy t\u1eafc cho b\u1ea3ng th\u1eddi ti\u1ebft s\u1ebd t\u00f4 n\u1ec1n m\u00e0u v\u00e0ng khi nhi\u1ec7t \u0111\u1ed9 cao h\u01a1n 60 \u00b0 F v\u1edbi, m\u00e0u da cam khi cao h\u01a1n 70 \u00b0 F v\u00e0 m\u00e0u \u0111\u1ecf khi cao h\u01a1n 80 \u00b0 F.<\/p>\n<p>B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch t\u1ea1o c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel theo ki\u1ec3u n\u00e0y \u2013 b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o\u00a0<strong><em>Conditional Formatting &gt; Highlight Cells rules &gt; Greater than<\/em><\/strong>.\u00a0Tuy nhi\u00ean, \u0111\u1ec3 c\u00e1c quy t\u1eafc ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, b\u1ea1n c\u0169ng c\u1ea7n ph\u1ea3i \u0111\u1eb7t m\u1ee9c \u01b0u ti\u00ean theo c\u00e1ch n\u00e0y:<\/p>\n<ol>\n<li>Nh\u1ea5p v\u00e0o\u00a0<strong><em>Conditional Formatting &gt; Manage Rules\u2026<\/em><\/strong><em>.<\/em>\u00a0\u0111\u1ec3 \u0111i t\u1edbi <strong><em>Rules Manager<\/em><\/strong>.<\/li>\n<li>Nh\u1ea5p v\u00e0o quy t\u1eafc c\u1ea7n \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng tr\u01b0\u1edbc ti\u00ean \u0111\u1ec3 ch\u1ecdn, v\u00e0 di chuy\u1ec3n l\u00ean ph\u00eda tr\u00ean b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng\u00a0<strong><em>upward arrow<\/em><\/strong>.\u00a0L\u00e0m t\u01b0\u01a1ng t\u1ef1 cho quy t\u1eafc th\u1ee9 hai.<\/li>\n<li>Ch\u1ecdn\u00a0h\u1ed9p ki\u1ec3m\u00a0<strong><em>Stop If True<\/em><\/strong>b\u00ean c\u1ea1nh hai quy t\u1eafc \u0111\u1ea7u ti\u00ean khi b\u1ea1n kh\u00f4ng mu\u1ed1n c\u00e1c quy t\u1eafc kh\u00e1c \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng khi \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng.<\/li>\n<\/ol>\n<p>\u00a0<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/7-4.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7655\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-4.bmp\" width=\"600\" height=\"551\" title=\"7-4\"><\/a><\/p>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng excel 2020<\/a><\/p>\n<\/blockquote>\n<p><strong>S\u1eed d\u1ee5ng \u201cStop If True\u201d trong c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong><\/p>\n<p>Ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng\u00a0t\u00f9y ch\u1ecdn\u00a0<strong><em>Stop If True<\/em><\/strong>\u00a0trong v\u00ed d\u1ee5 tr\u00ean \u0111\u1ec3 d\u1eebng x\u1eed l\u00fd c\u00e1c quy t\u1eafc kh\u00e1c khi \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng.\u00a0C\u00e1ch s\u1eed d\u1ee5ng \u0111\u00f3 r\u1ea5t r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 hi\u1ec3u.\u00a0B\u00e2y gi\u1edd ch\u00fang ta h\u00e3y xem x\u00e9t th\u00eam hai v\u00ed d\u1ee5 n\u1eefa khi vi\u1ec7c s\u1eed d\u1ee5ng <strong><em>Stop If True<\/em>\u00a0<\/strong>kh\u00f4ng r\u00f5 r\u00e0ng nh\u01b0ng c\u0169ng r\u1ea5t h\u1eefu \u00edch.<\/p>\n<p>V\u00ed d\u1ee5 1. Ch\u1ec9 hi\u1ec3n th\u1ecb m\u1ed9t s\u1ed1 m\u1ee5c c\u1ee7a bi\u1ec3u t\u01b0\u1ee3ng thi\u1ebft l\u1eadp<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n \u0111\u00e3 th\u00eam bi\u1ec3u t\u01b0\u1ee3ng sau \u0111\u00e2y v\u00e0o sales report.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"A sales report with icon sets\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sales-report.png\" alt=\"A sales report with icon sets\">Nh\u00ecn c\u00f3 v\u1ebb \u0111\u1eb9p, nh\u01b0ng c\u00f3 h\u01a1i r\u1ed1i.\u00a0V\u00ec v\u1eady, m\u1ee5c ti\u00eau c\u1ee7a ch\u00fang ta l\u00e0 ch\u1ec9 gi\u1eef c\u00e1c m\u0169i t\u00ean m\u00e0u \u0111\u1ecf \u0111i xu\u1ed1ng \u0111\u1ec3 thu h\u00fat s\u1ef1 ch\u00fa \u00fd \u0111\u1ebfn c\u00e1c s\u1ea3n ph\u1ea9m ho\u1ea1t \u0111\u1ed9ng d\u01b0\u1edbi m\u1ee9c trung b\u00ecnh v\u00e0 b\u1ecf c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng kh\u00e1c.\u00a0H\u00e3y xem l\u00e0m \u0111i\u1ec1u n\u00e0y nh\u01b0 th\u1ebf n\u00e0o:<\/p>\n<ol>\n<li>T\u1ea1o m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1edbi b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o\u00a0<em><strong>Conditional formatting &gt; New Rule &gt; Format only Cells that contain<\/strong><\/em>.<\/li>\n<li>B\u00e2y gi\u1edd b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1ecbnh h\u00ecnh quy t\u1eafc theo c\u00e1ch n\u00f3 ch\u1ec9 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n m\u1ee9c trung b\u00ecnh.\u00a0B\u1ea1n th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng\u00a0c\u00f4ng th\u1ee9c\u00a0<em>= AVERAGE ()<\/em>, nh\u01b0 th\u1ec3 hi\u1ec7n trong h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ol>\n<p><strong>M\u1eb9o.\u00a0<\/strong>B\u1ea1n lu\u00f4n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t d\u00e3y \u00f4 trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng bi\u1ec3u t\u01b0\u1ee3ng ch\u1ecdn ph\u1ea1m vi ti\u00eau chu\u1ea9n\u00a0 ho\u1eb7c g\u00f5 ph\u1ea1m vi b\u00ean trong c\u00e1c d\u1ea5u ngo\u1eb7c.\u00a0N\u1ebfu b\u1ea1n ch\u1ecdn c\u00e1ch th\u1ee9 hai, h\u00e3y nh\u1edb s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u1edbi d\u1ea5u $.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/8-2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7656\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-2.bmp\" width=\"600\" height=\"365\" title=\"8-2\"><\/a><\/p>\n<ol start=\"3\">\n<li>Nh\u1ea5p OK m\u00e0 kh\u00f4ng thi\u1ebft l\u1eadp b\u1ea5t k\u1ef3 \u0111\u1ecbnh d\u1ea1ng n\u00e0o.<\/li>\n<li>Nh\u1ea5p v\u00e0o\u00a0<strong><em>Conditional Formatting &gt; Manage Rules\u2026<\/em><\/strong>v\u00e0 \u0111\u00e1nh d\u1ea5u v\u00e0o\u00a0h\u1ed9p ki\u1ec3m\u00a0<strong><em>Stop if True<\/em>\u00a0<\/strong>\u00a0b\u00ean c\u1ea1nh quy t\u1eafc b\u1ea1n v\u1eeba t\u1ea1o. Xem k\u1ebft qu\u1ea3.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/9-3.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7657\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-3.bmp\" width=\"600\" height=\"502\" title=\"9-3\"><\/a><\/p>\n<blockquote>\n<p>T\u00ecm hi\u1ec3u v\u1ec1:\u00a0kh\u00f3a h\u1ecdc excel n\u00e2ng cao H\u00e0 N\u1ed9i<\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5 2. Lo\u1ea1i b\u1ecf \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u1edf c\u00e1c \u00f4 r\u1ed7ng<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n \u0111\u00e3 t\u1ea1o ra quy t\u1eafc \u201cBetween\u201d \u0111\u1ec3 \u0111\u00e1nh c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb t\u1eeb $0 \u0111\u1ebfn $1000, nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.\u00a0Nh\u01b0ng v\u1ea5n \u0111\u1ec1 l\u00e0 c\u00e1c \u00f4 tr\u1ed1ng c\u0169ng \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Empty cells are also highlighted with conditional formatting.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/empty-cells-formatted.png\" alt=\"Empty cells are also highlighted with conditional formatting.\"><\/p>\n<p>\u0110\u1ec3 kh\u1eafc ph\u1ee5c \u0111i\u1ec1u n\u00e0y, b\u1ea1n t\u1ea1o m\u1ed9t quy t\u1eafc n\u1eefa \u1edf \u00f4 \u201c<strong><em>Format only cells that contain<\/em><\/strong>\u201c.\u00a0Trong\u00a0h\u1ed9p tho\u1ea1i\u00a0<strong><em>New Formatting rule<\/em><\/strong>, ch\u1ecdn\u00a0<strong><em>Blanks<\/em>\u00a0<\/strong>t\u1eeb danh s\u00e1ch.<\/p>\n<p><em><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Create a conditional formatting rule for blank cells.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/blanks-rule.png\" alt=\"Create a conditional formatting rule for blank cells.\"><br \/>\n<\/em><\/p>\n<p>V\u00e0 m\u1ed9t l\u1ea7n n\u1eefa, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o\u00a0<em>OK<\/em>\u00a0m\u00e0 kh\u00f4ng c\u1ea7n c\u00e0i \u0111\u1eb7t b\u1ea5t k\u1ef3 \u0111\u1ecbnh d\u1ea1ng n\u00e0o.<\/p>\n<p>Cu\u1ed1i c\u00f9ng, m\u1edf\u00a0<em>\u00a0<strong>Conditional Formatting Rule Manager<\/strong> <\/em>v\u00e0 ch\u1ecdn\u00a0h\u1ed9p ki\u1ec3m\u00a0<strong><em>Stop if true<\/em><\/strong> b\u00ean c\u1ea1nh quy t\u1eafc \u201c<strong><em>Blanks<\/em><\/strong>\u201c.<\/p>\n<p>K\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u01b0 b\u1ea1n mong \u0111\u1ee3i.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/10-2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7658\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-2.bmp\" width=\"600\" height=\"511\" title=\"10-2\"><\/a><\/p>\n<p><strong>C\u00e1ch ch\u1ec9nh s\u1eeda c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/strong><\/p>\n<p>N\u1ebfu b\u1ea1n nh\u00ecn k\u1ef9 v\u00e0o \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y n\u00fat\u00a0<strong><em>Edit Rule\u2026<\/em><\/strong>\u00a0\u1edf \u0111\u00f3.\u00a0V\u00ec v\u1eady, n\u1ebfu b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng hi\u1ec7n c\u00f3, h\u00e3y ti\u1ebfp t\u1ee5c theo c\u00e1ch n\u00e0y:<\/p>\n<ol>\n<li>Ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o \u00e1p d\u1ee5ng quy t\u1eafc v\u00e0 nh\u1ea5p v\u00e0o\u00a0<strong><em>Conditional Formatting &gt; Manage Rules\u2026<\/em><\/strong><\/li>\n<li>Trong\u00a0<strong><em>Conditional Manager\u00a0Rules Manager<\/em><\/strong>, nh\u1ea5p v\u00e0o quy t\u1eafc b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda, v\u00e0 sau \u0111\u00f3 nh\u1ea5p n\u00fat <strong><em>Edit Rule\u2026<\/em><\/strong><em>.<\/em><\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/11-2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7659\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-2.bmp\" width=\"600\" height=\"282\" title=\"11-2\"><\/a><\/p>\n<ol start=\"3\">\n<li>Th\u1ef1c hi\u1ec7n c\u00e1c thay \u0111\u1ed5i c\u1ea7n thi\u1ebft trong\u00a0c\u1eeda s\u1ed5\u00a0<strong><em>Edit Formatting Rule<\/em><\/strong>v\u00e0 nh\u1ea5p v\u00e0o\u00a0<em>OK<\/em>\u00a0\u0111\u1ec3 l\u01b0u c\u00e1c ch\u1ec9nh s\u1eeda.<\/li>\n<\/ol>\n<p>C\u1ee7a s\u1ed5<em> <strong>Formatting Rule<\/strong><\/em> r\u1ea5t gi\u1ed1ng v\u1edbi\u00a0<strong><em>New Rule Formatting<\/em><\/strong> m\u00e0 b\u1ea1n s\u1eed d\u1ee5ng khi t\u1ea1o c\u00e1c quy t\u1eafc, do \u0111\u00f3 b\u1ea1n s\u1ebd kh\u00f4ng g\u1eb7p kh\u00f3 kh\u0103n g\u00ec.<\/p>\n<p><strong>M\u1eb9o.\u00a0<\/strong>N\u1ebfu b\u1ea1n kh\u00f4ng th\u1ea5y quy t\u1eafc b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda, h\u00e3y ch\u1ecdn\u00a0<strong>This Worksheet\u00a0<\/strong>\u00a0t\u1eeb\u00a0danh s\u00e1ch\u00a0\u201c<strong><em>Show formatting rules for<\/em><\/strong>\u201d \u0111\u1ec3 hi\u1ec3n th\u1ecb danh s\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c quy t\u1eafc trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/12-2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7660\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-2.bmp\" width=\"600\" height=\"292\" title=\"12-2\"><\/a><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/strong><\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n \u0111\u00e3 t\u1ea1o tr\u01b0\u1edbc \u0111\u00f3 cho c\u00e1c d\u1eef li\u1ec7u kh\u00e1c trong b\u1ea3ng t\u00ednh, b\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n t\u1ea1o l\u1ea1i quy t\u1eafc t\u1eeb \u0111\u1ea7u.\u00a0\u0110\u01a1n gi\u1ea3n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng\u00a0<strong><em>Format Painter<\/em><\/strong>\u00a0\u0111\u1ec3 sao ch\u00e9p c\u00e1c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n hi\u1ec7n c\u00f3 v\u00e0o b\u1ed9 d\u1eef li\u1ec7u m\u1edbi.<\/p>\n<ol>\n<li>Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o c\u00f3 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1ea1n mu\u1ed1n sao ch\u00e9p.<\/li>\n<li>Nh\u1ea5p\u00a0<strong><em>Home &gt; Format Painter<\/em><\/strong>.\u00a0\u0110i\u1ec1u n\u00e0y s\u1ebd thay \u0111\u1ed5i con tr\u1ecf chu\u1ed9t th\u00e0nh m\u1ed9t c\u00e2y c\u1ecd.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Copy conditional formatting in Excel.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-painter.png\" alt=\"Copy conditional formatting in Excel.\"><\/p>\n<p><strong>M\u1eb9o.\u00a0<\/strong>B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p \u0111\u00fap v\u00e0o\u00a0<strong><em>Format Painter<\/em><\/strong>\u00a0n\u1ebfu b\u1ea1n mu\u1ed1n d\u00e1n \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t s\u1ed1 d\u1ea3i \u00f4 kh\u00e1c nhau.<\/p>\n<ol start=\"3\">\n<li>\u0110\u1ec3 d\u00e1n \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, nh\u1ea5p v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean v\u00e0 k\u00e9o c\u00e2y c\u1ecd xu\u1ed1ng \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng trong d\u1ea3i \u00f4 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Paste the conditional formatting to another range of cells.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-conditional-formatting.png\" alt=\"Paste the conditional formatting to another range of cells.\"><\/p>\n<ol start=\"4\">\n<li>Khi ho\u00e0n t\u1ea5t, nh\u1ea5n\u00a0<em>Esc<\/em>\u0111\u1ec3 d\u1eebng s\u1eed d\u1ee5ng c\u1ecd.<\/li>\n<\/ol>\n<p><strong>Ch\u00fa \u00dd.\u00a0<\/strong>N\u1ebfu b\u1ea1n \u0111\u00e3 t\u1ea1o quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n ph\u1ea3i \u0111i\u1ec1u ch\u1ec9nh c\u00e1c tham chi\u1ebfu \u00f4 trong c\u00f4ng th\u1ee9c sau khi sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p><strong>C\u00e1ch x\u00f3a c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong><\/p>\n<p>\u0110\u1ec3 x\u00f3a m\u1ed9t quy t\u1eafc, b\u1ea1n c\u00f3 th\u1ec3:<\/p>\n<ul>\n<li>M\u1edf\u00a0<strong><em>Conditional Manager\u00a0Rules Manager<\/em><\/strong><em> (<\/em>th\u00f4ng qua<strong>C<\/strong><strong><em>onditional Formatting &gt; Manage Rules\u2026<\/em><\/strong>), ch\u1ecdn quy t\u1eafc v\u00e0 nh\u1ea5p v\u00e0o n\u00fat\u00a0<strong><em>Delete Rule<\/em><\/strong>.<\/li>\n<li>Ch\u1ecdn d\u1ea3i \u00f4, nh\u1ea5p\u00a0<strong><em>Conditional Formatting &gt; Clear Rules<\/em><\/strong>v\u00e0 ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn c\u00f3 s\u1eb5n.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Delete conditional formatting rules in Excel.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/delete-conditional-formatting-rule.png\" alt=\"Delete conditional formatting rules in Excel.\"><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 bi\u1ebft th\u00eam nhi\u1ec1u h\u00e0m n\u00e2ng cao trong Excel c\u0169ng nh\u01b0 s\u1eed d\u1ee5ng t\u1ed1t h\u01a1n c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, c\u00e1c b\u1ea1n h\u00e3y tham gia ngay 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 n\u00e2ng cao<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc chi ti\u1ebft v\u00e0 \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, gi\u00fap b\u1ea1n ph\u00e1t tri\u1ec3n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng. \u0110\u1eb7c bi\u1ec7t kh\u00f3a h\u1ecdc n\u00e0y kh\u00f4ng gi\u1edbi h\u1ea1n th\u1eddi gian h\u1ecdc t\u1eadp, n\u00ean b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc tho\u1ea3i m\u00e1i v\u00e0 xem l\u1ea1i b\u1ea5t c\u1ee9 khi n\u00e0o.<\/p>\n<p>Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Kho\u00e1 h\u1ecdc Excel t\u1eeb H\u1ecdc Excel Online<\/a><\/p>\n<p><strong>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-excel-de-dinh-dang-co-dieu-kien-dua-tren-gia-tri-o-khac.html\">T\u00f4 m\u00e0u d\u00f2ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<\/a>, gi\u1ea3i quy\u1ebft nh\u1eefng b\u00e0i to\u00e1n kh\u00f3<\/strong><\/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-113.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3373,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3372","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\/3372","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=3372"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3372\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3373"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}