{"id":3527,"date":"2014-05-11T14:36:16","date_gmt":"2014-05-11T14:36:16","guid":{"rendered":"http:\/\/tapchicntt.com\/?p=3527"},"modified":"2014-05-11T14:36:16","modified_gmt":"2014-05-11T14:36:16","slug":"thu-thuat-to-mau-xen-ke-cac-dong-tren-bang-tinh-lon-trong-excel","status":"publish","type":"post","link":"https:\/\/tapchicntt.com\/thu-thuat-to-mau-xen-ke-cac-dong-tren-bang-tinh-lon-trong-excel\/","title":{"rendered":"Th\u1ee7 thu\u1eadt t\u00f4 m\u00e0u xen k\u1ebd c\u00e1c d\u00f2ng tr\u00ean b\u1ea3ng t\u00ednh l\u1edbn trong Excel"},"content":{"rendered":"

Khi s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u th\u1ed1ng k\u00ea theo d\u1ea1ng danh s\u00e1ch, v\u00e0 khi nh\u00ecn v\u00e0o danh s\u00e1ch tr\u00ean m\u1ed9t n\u1ec1n m\u00e0u tr\u1eafng khi\u1ebfn ng\u01b0\u1eddi \u0111\u1ecdc r\u1ed1i m\u1eaft.Th\u1ee7 thu\u1eadt t\u00f4 m\u00e0u xen k\u1ebd c\u00e1c d\u00f2ng tr\u00ean b\u1ea3ng t\u00ednh l\u1edbn trong Excel gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 n\u1eafm b\u1eaft d\u1eef li\u1ec7u c\u0169ng nh\u01b0 tra c\u1ee9u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng m\u00e0 kh\u00f4ng b\u1ecb nh\u1ea7m l\u1ea7n. Th\u1ee7 thu\u1eadt EXCEL n\u00e0y gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian thay v\u00ec ph\u1ea3i t\u00f4 m\u00e0u cho t\u1eebng d\u00f2ng l\u1eb7p \u0111i l\u1eb7p l\u1ea1i. <\/p>\n

\"\"<\/p>\n

B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n th\u1ee7 thu\u1eadt n\u00e0y m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng trong Microsoft Excel 2007, Excel 2010, Excel 2013 nh\u01b0 sau:<\/p>\n

\u0110\u1ec3 t\u00f4 m\u00e0u xen k\u1ebd c\u00e1c d\u00f2ng trong to\u00e0n b\u1ed9 Sheet b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn Ctrl +A, ho\u1eb7c nh\u1ea5n v\u00e0o n\u00fat tam gi\u00e1c m\u00e0u n\u00e2u \u1edf g\u00f3c tr\u00e1i Worksheet \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3.<\/p>\n

N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n t\u00f4 m\u00e0u c\u00e1c d\u00f2ng trong 1 kh\u1ed1i nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n ch\u1ec9 vi\u1ec7c d\u00f9ng chu\u1ed9t qu\u00e9t kh\u1ed1i \u0111\u00f3.<\/p>\n

\"\"<\/p>\n

Tr\u00ean th\u1ebb Home c\u1ee7a thanh Ribbon, Ch\u1ecdn Style \u2013> Conditional Formatting<\/p>\n

\"\"<\/p>\n

Khi b\u1ea1n ch\u1ecdn v\u00e0o m\u1ee5c Conditional Formatting, Tr\u00ean Menu s\u1ed5 xu\u1ed1ng, ch\u1ecdn New Rule<\/p>\n

\"\"<\/p>\n

T\u1ea1i \u00f4 Format values where this formular is true, b\u1ea1n g\u00f5 c\u00f4ng th\u1ee9c sau: =MOD(ROW(),2)>0<\/p>\n

\"\"<\/p>\n

Sau \u0111\u00f3 Click v\u00e0o n\u00fat Format, 1 h\u1ed9p tho\u1ea1i Format Cells s\u1ebd m\u1edf ra, t\u1ea1i Tab Fill b\u1ea1n ch\u1ecdn m\u00e0u s\u1eafc mu\u00f4n t\u00f4 m\u00e0u cho d\u00f2ng \u2013> Click Ok<\/p>\n

\"\"<\/p>\n

Sau khi \u0111\u00e3 \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 c\u00f4ng th\u1ee9c v\u00e0 ch\u1ecdn m\u00e0u s\u1eafc, b\u01b0\u1edbc cu\u1ed1i c\u00f9ng l\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n OK v\u00e0 xem k\u1ebft qu\u1ea3<\/p>\n

\"\"<\/p>\n

N\u1ebfu b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i m\u00e0u s\u1eafc tr\u00ean d\u00f2ng, b\u1ea1n ho\u00e0n to\u00e0n kh\u00f4ng ph\u1ea3i l\u1eb7p l\u1ea1i c\u00e1c b\u01b0\u1edbc tr\u00ean, m\u00e0 ch\u1ec9 c\u1ea7n t\u00edch chu\u1ed9t ph\u1ea3i ch\u1ecdn Manage Rule<\/p>\n

\"\"<\/p>\n

T\u1eeb h\u1ed9p tho\u1ea1i Conditional Formatting Rule Manager \u2013> ch\u1ecdn Edit Rule<\/p>\n

\"\"<\/p>\n

Nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 Format, Setup l\u1ea1i m\u00e0u s\u1eafc<\/p>\n

\"\"<\/p>\n

Nh\u01b0 v\u1eady, \u0111\u1ecbnh d\u1ea1ng c\u1ee7a kh\u1ed1i \u00f4 \u0111\u00e3 thay \u0111\u1ed5i so v\u1edbi ban \u0111\u1ea7u khi th\u1ef1c hi\u1ec7n thao t\u00e1c Edit Rule<\/p>\n

\"\"<\/p>\n

Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n","protected":false},"excerpt":{"rendered":"

Khi s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u th\u1ed1ng k\u00ea theo d\u1ea1ng danh s\u00e1ch, v\u00e0 khi nh\u00ecn v\u00e0o […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[],"class_list":["post-3527","post","type-post","status-publish","format-standard","hentry","category-van-phong"],"views":443,"_links":{"self":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/3527","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/comments?post=3527"}],"version-history":[{"count":0,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/3527\/revisions"}],"wp:attachment":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/media?parent=3527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/categories?post=3527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/tags?post=3527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}