{"id":12413,"date":"2025-01-15T08:39:51","date_gmt":"2025-01-15T08:39:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/to-mau-dong-xen-ke-trong-bang-tinh-excel-2010-2013-2016\/"},"modified":"2025-01-15T08:39:51","modified_gmt":"2025-01-15T08:39:51","slug":"to-mau-dong-xen-ke-trong-bang-tinh-excel-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/to-mau-dong-xen-ke-trong-bang-tinh-excel-2010-2013-2016\/","title":{"rendered":"T\u00f4 m\u00e0u d\u00f2ng xen k\u1ebd trong b\u1ea3ng t\u00ednh Excel 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>V\u1edbi m\u1ed9t l\u01b0\u1ee3ng l\u1edbn s\u1ed1 li\u1ec7u khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Excel, \u00a0n\u1ebfu kh\u00f4ng c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t gi\u1eefa c\u00e1c th\u00f4ng tin th\u00ec kh\u1ea3 n\u0103ng b\u1ecb nh\u1ea7m l\u1eabn l\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i cao. Do \u0111\u00f3, \u0111a s\u1ed1 ng\u01b0\u1eddi r\u00e0nh Excel \u0111\u1ec1u d\u00f9ng c\u00f4ng c\u1ee5 t\u00f4 m\u00e0u d\u00f2ng xen k\u1ebd v\u1edbi nhau nh\u1eb1m h\u1ea1n ch\u1ebf t\u00ecnh tr\u1ea1ng \u0111\u00f3.<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">B\u00e0i vi\u1ebft sau \u0111\u00e2y, m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n k\u1ef9 thu\u1eadt<strong> t\u00f4 m\u00e0u d\u00f2ng<\/strong> xen k\u1ebd m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, gi\u00fap danh s\u00e1ch b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n r\u00f5 r\u00e0ng v\u00e0 \u0111\u1eb9p m\u1eaft h\u01a1n.<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>B\u01b0\u1edbc 1<\/strong>: M\u1edf file excel c\u1ea7n l\u00e0m vi\u1ec7c. \u00a0\u1ede m\u1ee5c\u00a0<strong>Home,<\/strong>\u00a0ch\u1ecdn\u00a0<strong>Conditional Formatting<\/strong> trong nh\u00f3m <strong>Style<\/strong>, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>New Rule<\/strong> trong menu s\u1ed5 xu\u1ed1ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3134 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-8-1.png\" width=\"600\" height=\"280\" title=\"1-8-1\"><\/p>\n<ul style=\"text-align: justify\">\n<li><strong>B\u01b0\u1edbc 2<\/strong>: Trong h\u1ed9p tho\u1ea1i <strong>New Formatting Rule<\/strong>, ch\u1ecdn m\u1ee5c <strong>Use a formula to determine which cells to format. \u00a0<\/strong>\u1ede m\u1ee5c\u00a0<strong>Format values where this formular is true<\/strong>, b\u1ea1n g\u00f5 c\u00f4ng th\u1ee9c sau: <strong>=MOD(ROW(),2)&gt;0<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3135 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-9.png\" width=\"600\" height=\"607\" title=\"1-9\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">N\u00ean xem: C\u00e1c ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">h\u1ecdc Excel 2010<\/a><\/p>\n<\/blockquote>\n<ul style=\"text-align: justify\">\n<li><strong>B\u01b0\u1edbc 3:<\/strong> \u0110\u1ec3 ch\u1ecdn m\u00e0u t\u00f4 cho c\u00e1c d\u00f2ng xen k\u1ebd, b\u1ea1n nh\u1ea5p v\u00e0o\u00a0<strong>Format<\/strong>, h\u1ed9p tho\u1ea1i\u00a0<strong>Format Cells<\/strong>\u00a0xu\u1ea5t hi\u1ec7n, nh\u1ea5p ch\u1ecdn tab\u00a0<strong>Fill<\/strong>\u00a0v\u00e0 ch\u1ecdn m\u00e0u mu\u1ed1n t\u00f4. V\u00e0 cu\u1ed1i c\u00f9ng nh\u1ea5n <strong>O<\/strong><strong>K<\/strong> \u0111\u1ec3 k\u1ebft th\u00fac.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3136 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-10-1.png\" width=\"600\" height=\"582\" title=\"1-10-1\"><\/p>\n<ul style=\"text-align: justify\">\n<li>K\u1ebft qu\u1ea3:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3137 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-11.png\" width=\"600\" height=\"273\" title=\"1-11\"><\/p>\n<p style=\"text-align: justify\">* <strong>N\u1ebfu b\u1ea1n mu\u1ed1n ch\u1ecdn m\u00e0u s\u1eafc kh\u00e1c<\/strong>, nh\u1ea5p ch\u1ecdn <strong>Conditional Formatting<\/strong> sau \u0111\u00f3 nh\u1ea5p v\u00e0o <strong>Manage Rule<\/strong>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3138 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-12.png\" width=\"600\" height=\"641\" title=\"1-12\"><\/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\/2025\/01\/ex101_92019-nho-396.gif\" title=\"ex101_92019-nho-396\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"text-align: justify\">\n<li>H\u1ed9p tho\u1ea1i\u00a0<strong>Conditional Formatting Rule Manager<\/strong> xu\u1ea5t hi\u1ec7n b\u1ea1n ch\u1ecdn m\u1ee5c <strong>Edit Rule<\/strong><strong>.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3139 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-13-1.png\" width=\"600\" height=\"338\" title=\"1-13-1\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4\u00a0<strong>Format<\/strong> v\u00e0 ti\u1ebfn h\u00e0nh ch\u1ecdn l\u1ea1i m\u00e0u b\u1ea1n mu\u1ed1n \u0111\u1ed5i (\u1edf \u0111\u00e2y Hocexcel\u00a0ch\u1ecdn m\u00e0u v\u00e0ng). Sau \u0111\u00f3 nh\u1ea5n <strong>OK<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3141 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-14.png\" width=\"600\" height=\"358\" title=\"1-14\"><\/p>\n<ul style=\"text-align: justify\">\n<li>K\u1ebft qu\u1ea3:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3142 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-15.png\" width=\"600\" height=\"378\" title=\"1-15\"><\/p>\n<p style=\"text-align: justify\">Hi v\u1ecdng, qua c\u00e1c thao t\u00e1c h\u01b0\u1edbng d\u1eabn kh\u00e1 chi ti\u1ebft tr\u00ean \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 <strong>t\u00f4 m\u00e0u d\u00f2ng<\/strong> xen k\u1ebd trong Excel m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">\u0110\u1eebng b\u1ecf l\u1ee1:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">C\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng trong Excel<\/a><\/p>\n<\/blockquote>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/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-396.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12413","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\/12413","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=12413"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12414"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}