{"id":12476,"date":"2025-01-15T09:00:19","date_gmt":"2025-01-15T09:00:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/bat-tat-conditional-formatting\/"},"modified":"2025-01-15T09:00:19","modified_gmt":"2025-01-15T09:00:19","slug":"bat-tat-conditional-formatting","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/bat-tat-conditional-formatting\/","title":{"rendered":"B\u1eadt t\u1eaft conditional formatting"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng nhau \u0111i t\u00ecm hi\u1ec3u k\u0129 thu\u1eadt s\u1eed d\u1ee5ng conditional formatting \u2013 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n k\u1ebft h\u1ee3p v\u1edbi Form Control \u2013 1 checkbox \u0111\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c file Excel nh\u01b0 sau:<\/p>\n

\"b\u1eadt<\/a><\/p>\n

B\u01b0\u1edbc 1: M\u1edf th\u1ebb Developer<\/strong><\/p>\n

    \n
  1. Click v\u00e0o th\u1ebb File > Options<\/li>\n
  2. Trong c\u1eeda s\u1ed5 Excel Options > Customize Ribbons v\u00e0 tick v\u00e0o Developer nh\u01b0 h\u00ecnh<\/li>\n<\/ol>\n

    \"h\u1ecdc<\/p>\n

    B\u01b0\u1edbc 2: <\/strong>Th\u00eam Checkbox<\/p>\n

    V\u00e0o th\u1ebb Developer > ch\u1ecdn Insert > Form Control: Checkbox > V\u1ebd 1 check box tr\u00ean b\u1ea3ng t\u00ednh Excel<\/p>\n

    \"check<\/p>\n

    B\u01b0\u1edbc 3:\u00a0<\/strong><\/p>\n

    \n
    \n
    \n
    \n<\/a>\n<\/div>\n<\/div>\n
    \n
    \n
    \n
    \n<\/a>\n<\/div>\n<\/div>\n
      \n
    1. V\u1ebd check box, \u0111\u1ed5i t\u00ean<\/li>\n
    2. B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o checkbox r\u1ed3i ch\u1ecdn Format Control \u2026<\/strong><\/li>\n<\/ol>\n

      \"format<\/p>\n

      B\u01b0\u1edbc 4<\/strong><\/p>\n

      Trong c\u1eeda s\u1ed5 Format Object, <\/strong>th\u1ebb Control,\u00a0<\/strong>ch\u1ecdn \u00f4 m\u00e0 check box \u0111\u01b0\u1ee3c li\u00ean k\u1ebft t\u1edbi, trong v\u00ed d\u1ee5 l\u00e0 \u00f4 G1. Gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 G1 b\u00e2y gi\u1edd s\u1ebd c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u0111i\u1ec1u khi\u1ec3n t\u1eeb checkbox, n\u1ebfu checkbox \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u, \u00f4 G1 s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb TRUE, n\u1ebfu kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u, \u00f4 G1 s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb FALSE.<\/p>\n

      <\/p>\n

      \u00a0<\/p>\n

      B\u01b0\u1edbc 5<\/strong><\/p>\n

        \n
      1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u A2:E11<\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng Conditional Formatting<\/li>\n
      2. Th\u1ebb Home > Conditional Formatting > New Rules > Use a formula to determine which cells to format v\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c: =AND(MOD(ROW(),2)=1,$G$1)<\/strong><\/li>\n
      3. B\u1ea5m n\u00fat Format \u2026 v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p, r\u1ed3i b\u1ea5m OK.<\/li>\n
      4. T\u1eadn h\u01b0\u1edfng k\u1ebft qu\u1ea3.<\/li>\n<\/ol>\n

        B\u1ea1n c\u00f3 th\u1ec3 download file v\u1ec1 \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam:<\/strong><\/p>\n

        [sociallocker id=2748]<\/p>\n

        DOWNLOAD<\/a><\/p>\n

        [\/sociallocker]<\/p>\n

        Kh\u00e1m ph\u00e1 th\u00eam th\u1eadt nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1edbi H\u1ecdc Excel Online:<\/strong><\/p>\n

          \n
        1. H\u1ecdc Excel, C\u00f3 Vi\u1ec7c Ngay: https:\/\/www.hocexcel.online\/ex101<\/a><\/li>\n
        2. H\u00e3y \u0111\u1ec3 VBA gi\u00fap b\u1ea1n: https:\/\/www.hocexcel.online\/vba101<\/a><\/li>\n
        3. Hi\u1ec3u v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Excel: https:\/\/www.hocexcel.online\/dv101<\/a><\/li>\n
        4. H\u00e3y l\u00e0m k\u1ebf to\u00e1n v\u1edbi VBA: https:\/\/www.hocexcel.online\/im101<\/a><\/li>\n
        5. Qu\u1ea3n l\u00fd kho h\u00e0ng trong Excel: https:\/\/www.hocexcel.online\/im201<\/a><\/li>\n<\/ol>\n<\/div>\n
          \n

          Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

          T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

          H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

          HKD H\u1ecdc Excel Online
          S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

          \n

          \u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          \n
          \n
          \n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12476","post","type-post","status-publish","format-standard","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12476","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=12476"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12476\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}