{"id":3635,"date":"2024-12-03T03:14:46","date_gmt":"2024-12-03T03:14:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/to-mau-co-dieu-kien-cho-ca-dong-du-lieu-excel\/"},"modified":"2024-12-03T03:14:46","modified_gmt":"2024-12-03T03:14:46","slug":"to-mau-co-dieu-kien-cho-ca-dong-du-lieu-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/to-mau-co-dieu-kien-cho-ca-dong-du-lieu-excel\/","title":{"rendered":"T\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho c\u1ea3 d\u00f2ng d\u1eef li\u1ec7u Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ea3 d\u00f2ng d\u1eef li\u1ec7u trong Excel \u0111\u00fang c\u00e1ch, gi\u00fap c\u00e1c b\u1ea1n l\u00e0m n\u1ed5i b\u1eadt, ph\u00e2n bi\u1ec7t c\u00e1c d\u1eef li\u1ec7u d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh khi thao t\u00e1c v\u1edbi t\u1ec7p d\u1eef li\u1ec7u l\u1edbn, t\u1eeb \u0111\u00f3 d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng c\u00e1c d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mong mu\u1ed1n.<\/p>\n<h2>S\u1eed d\u1ee5ng t\u00ednh n\u0103ng conditional formatting \u0111\u1ec3 t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho c\u1ea3 d\u00f2ng d\u1eef li\u1ec7u trong Excel<\/h2>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/ih_PbY_fhvU\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p style=\"text-align: left\">\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<\/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 theo \u0111i\u1ec1u ki\u1ec7n trong excel<\/a> \u00e1p d\u1ee5ng c\u1ea3 nh\u1eefng b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p<\/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":"<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u00f4 m\u00e0u c\u00f3..<\/p>\n","protected":false},"author":1,"featured_media":3636,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3635","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\/3635","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=3635"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3635\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3636"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}