{"id":17055,"date":"2026-07-14T18:36:22","date_gmt":"2026-07-14T11:36:22","guid":{"rendered":"https:\/\/tct.vn\/blog\/lam-the-nao-de-ap-dung-dinh-dang-dieu-kien-cho-tat-ca-cac-bang-tinh-excel\/"},"modified":"2026-07-14T18:36:22","modified_gmt":"2026-07-14T11:36:22","slug":"lam-the-nao-de-ap-dung-dinh-dang-dieu-kien-cho-tat-ca-cac-bang-tinh-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/lam-the-nao-de-ap-dung-dinh-dang-dieu-kien-cho-tat-ca-cac-bang-tinh-excel\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n cho t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh Excel"},"content":{"rendered":"<p>Quick Tips Kh\u00f4ng th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n t\u1ef1 \u0111\u1ed9ng tr\u00ean nhi\u1ec1u b\u1ea3ng t\u00ednh trong c\u00e1c phi\u00ean b\u1ea3n g\u1ea7n \u0111\u00e2y c\u1ee7a Excel. C\u00f3 m\u1ed9t c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Ch\u00e9p v\u00e0 D\u00e1n ho\u1eb7c B\u1ed9 c\u00f4ng c\u1ee5 \u0111\u1ecbnh d\u1ea1ng. L\u01b0u \u00fd khi vi\u1ebft m\u00e3 VBA... [N\u1ed9i dung \u0111\u1ea7y \u0111\u1ee7 v\u00e0 h\u00ecnh \u1ea3nh \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111\u1ed1i v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng]<\/p>","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng \u0111\u1ec3 kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 kh\u00f4ng th\u1ec3 t\u1ef1 \u0111\u1ed9ng sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n trong Excel? H\u00e3y th\u1eed ph\u01b0\u01a1ng ph\u00e1p &#8220;Sao ch\u00e9p v\u00e0 D\u00e1n&#8221; ho\u1eb7c s\u1eed d\u1ee5ng B\u1ed9 c\u00f4ng c\u1ee5 \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n cho t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh... [N\u1ed9i dung \u0111\u1ea7y \u0111\u1ee7 v\u00e0 h\u00ecnh \u1ea3nh \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111\u1ed1i v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng]<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[507,506],"tags":[],"class_list":["post-17055","post","type-post","status-publish","format-standard","hentry","category-cong-nghe","category-thu-thuat"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/17055","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=17055"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/17055\/revisions"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=17055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=17055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=17055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}