{"id":11801,"date":"2025-01-15T05:12:42","date_gmt":"2025-01-15T05:12:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-to-dam-cach-hang-trong-excel\/"},"modified":"2025-01-15T05:12:42","modified_gmt":"2025-01-15T05:12:42","slug":"cach-to-dam-cach-hang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-to-dam-cach-hang-trong-excel\/","title":{"rendered":"C\u00e1ch t\u00f4 \u0111\u1eadm c\u00e1ch h\u00e0ng trong Excel"},"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=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u00f4 \u0111\u1eadm c\u00e1ch c\u1ed9t ho\u1eb7c d\u00f2ng trong Excel.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch t\u00f4 \u0111\u1eadm c\u00e1ch h\u00e0ng b\u1eb1ng c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">Video minh ho\u1ea1 k\u0129 thu\u1eadt n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/hWRBuf_xVAM\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p style=\"text-align: justify\">1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n t\u00f4 \u0111\u1eadm, nh\u1ea5n <em><strong>Home&gt;&gt;\u00a0Conditional Formatting&gt;&gt;\u00a0New Rule\u2026<\/strong><\/em>.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-shade-alternate-rows.png\" title=\"doc-shade-alternate-rows\"><\/p>\n<p style=\"text-align: justify\">2. H\u1ed9p tho\u1ea1i <em><strong>New Formatting Rule\u00a0<\/strong><\/em>xu\u1ea5t hi\u1ec7n. Ch\u1ecdn <em><strong>Use a formula to determine which cells to format<\/strong><\/em>. Nh\u1eadp c\u00f4ng th\u1ee9c <em><strong>=MOD(ROW(),2)<\/strong><\/em>\u00a0v\u00e0o <em><strong>Format values where this formula is true<\/strong><\/em>.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-shade-alternate-rows-1.png\" title=\"doc-shade-alternate-rows-1\"><\/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\/2025\/01\/vba101_92019-nho-61.gif\" title=\"vba101_92019-nho-61\"><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\/2025\/01\/ex101_92019-nho-326.gif\" title=\"ex101_92019-nho-326\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">3. Nh\u1ea5n n\u00fat <em><strong>Format\u2026<\/strong><\/em>, h\u1ed9p tho\u1ea1i <em><strong>Format Cells <\/strong><\/em>kh\u00e1c\u00a0hi\u1ec7n ra. V\u00e0o th\u1ebb <em><strong>Fill<\/strong><\/em>, ch\u1ecdn m\u1ed9t m\u00e0u \u0111\u1ec3 t\u00f4.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-shade-alternate-rows-3.png\" title=\"doc-shade-alternate-rows-3\"><\/p>\n<p style=\"text-align: justify\">4. Nh\u1ea5n OK \u0111\u1ec3 quay v\u1ec1 h\u1ed9p tho\u1ea1i <em><strong>New Formatting Rule<\/strong><\/em>, b\u1ea1n s\u1ebd th\u1ea5y m\u00e0u \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u00f4 <em><strong>Preview<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\">5. Nh\u1ea5n OK. B\u1ea1n \u0111\u00e3 c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 \u00fd.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7518\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/untitled-39.png\" width=\"600\" height=\"239\" title=\"untitled-39\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong><\/p>\n<p style=\"text-align: justify\">1. Ch\u00e8n ho\u1eb7c x\u00f3a h\u00e0ng trong v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u00f4 \u0111\u1eadm th\u00ec m\u00e0u c\u1ee7a d\u00f2ng \u0111\u01b0\u1ee3c t\u00f4 v\u1eabn t\u1ed3n t\u1ea1i.<\/p>\n<p style=\"text-align: justify\">2. N\u1ebfu b\u1ea1n mu\u1ed1n t\u00f4 m\u00e0u c\u1ed9t, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:\u00a0<em><strong>=MOD(COLUMN(),2)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">\u2014\u2014\u2014\u2014\u2014<\/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<\/p>\n<p>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<\/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\/2025\/01\/vba101_92019-nho-61.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11802,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11801","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\/11801","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=11801"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11801\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11802"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}