{"id":7841,"date":"2024-12-21T18:38:18","date_gmt":"2024-12-21T18:38:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-dinh-dang-co-dieu-kien-icon-sets-data-bars-va-color-scales\/"},"modified":"2024-12-21T18:38:18","modified_gmt":"2024-12-21T18:38:18","slug":"huong-dan-dinh-dang-co-dieu-kien-icon-sets-data-bars-va-color-scales","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-dinh-dang-co-dieu-kien-icon-sets-data-bars-va-color-scales\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Icon Sets, Data Bars v\u00e0 Color Scales"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng Icon Sets, Data Bars v\u00e0 Color Scales c\u1ee7a nh\u00f3m \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel 2016, 2013, 2010 v\u00e0 2007. \u0110\u1ed3ng th\u1eddi s\u1ebd gi\u00fap b\u1ea1n m\u1edf r\u1ed9ng vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e0y v\u00e0 \u00e1p d\u1ee5ng c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 kh\u00e1c.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67670b193a46c\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-dinh-dang-co-dieu-kien-icon-sets-data-bars-va-color-scales.html#Dinh_dang_co_dieu_kien_cua_Icon_Sets_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Icon Sets trong Excel\">\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Icon Sets trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-dinh-dang-co-dieu-kien-icon-sets-data-bars-va-color-scales.html#Cach_ap_dung_mot_tap_hop_bieu_tuong_Excel_dua_tren_gia_tri_cua_cac_o\" title=\"C\u00e1ch \u00e1p d\u1ee5ng m\u1ed9t t\u1eadp h\u1ee3p bi\u1ec3u t\u01b0\u1ee3ng Excel d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4:\">C\u00e1ch \u00e1p d\u1ee5ng m\u1ed9t t\u1eadp h\u1ee3p bi\u1ec3u t\u01b0\u1ee3ng Excel d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-dinh-dang-co-dieu-kien-icon-sets-data-bars-va-color-scales.html#Dinh_dang_co_dieu_kien_Data_Bars\" title=\"\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Data Bars\">\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Data Bars<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-dinh-dang-co-dieu-kien-icon-sets-data-bars-va-color-scales.html#Dinh_dang_co_dieu_kien_Color_Scales\" title=\"\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Color Scales\">\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Color Scales<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dinh_dang_co_dieu_kien_cua_Icon_Sets_trong_Excel\"><\/span><strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Icon Sets<\/strong><strong> trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e1c bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel s\u1ebd gi\u00fap b\u1ea1n bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh m\u1ed9t c\u00e1ch tr\u1ef1c quan b\u1eb1ng m\u0169i t\u00ean, h\u00ecnh d\u1ea1ng, d\u1ea5u check, c\u1edd, \u0111\u00e1nh gi\u00e1 theo sao v\u00e0 c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n d\u00f9ng b\u1ed9 bi\u1ec3u t\u01b0\u1ee3ng cho d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o <strong>Conditional Formatting&gt;Icon Sets<\/strong>, v\u00e0 c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng xu\u1ea5t hi\u1ec7n b\u00ean trong c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn ngay.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-124.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4875 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-124.bmp\" width=\"558\" height=\"476\" title=\"new-bitmap-image-2-124\"><\/a><\/p>\n<p style=\"text-align: justify\">Trong h\u00ecnh \u1edf tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 xem b\u1ea3ng li\u1ec7t k\u00ea chi ti\u00eau gia \u0111\u00ecnh v\u1edbi v\u00f2ng tr\u00f2n m\u00e0u xanh l\u00e1 c\u00e2y bi\u1ec3u th\u1ecb gi\u00e1 tr\u1ecb cao nh\u1ea5t v\u00e0 m\u00e0u \u0111\u1ecf cho gi\u00e1 tr\u1ecb th\u1ea5p h\u01a1n. Ta kh\u00f4ng th\u1ec3 n\u00f3i r\u1eb1ng Excel \u0111\u00e3 gi\u1ea3i th\u00edch d\u1eef li\u1ec7u theo c\u00e1ch ta mu\u1ed1n, v\u00ec v\u1eady ch\u00fang ta h\u00e3y t\u00f9y ch\u1ec9nh vi\u1ec7c thi\u1ebft l\u1eadp bi\u1ec3u t\u01b0\u1ee3ng m\u1ed9t ch\u00fat. \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, h\u00e3y nh\u1ea5p <strong>More Rules\u2026<\/strong> b\u00ean d\u01b0\u1edbi danh s\u00e1ch t\u1eadp h\u1ee3p bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>New Formatting Rule<\/strong>.<\/p>\n<p style=\"text-align: justify\">T\u1eeb \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng kh\u00e1c v\u00e0 g\u00e1n ch\u00fang cho c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau. Ta ch\u1ecdn c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0ng ch\u1ec9 \u0111\u1ecbnh ch\u00fang theo m\u1ed9t c\u00e1ch kh\u00e1c:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-125.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4876 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-125.bmp\" width=\"600\" height=\"438\" title=\"new-bitmap-image-2-125\"><\/a><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-320.gif\" title=\"vba101_92019-nho-320\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2024\/12\/ex101_92019-nho-705.gif\" title=\"ex101_92019-nho-705\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ec3 thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng, nh\u1ea5p v\u00e0o n\u00fat <strong>Reverse Icon Order<\/strong>.<\/li>\n<li>\u0110\u1ec3 \u1ea9n c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4, h\u00e3y ch\u1ecdn h\u1ed9p <strong>Show Icon Only<\/strong>.<\/li>\n<li>\u0110\u1ec3 g\u00e1n c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 thay v\u00ec ch\u1ec9 \u0111\u1ecbnh m\u1ed9t s\u1ed1 ho\u1eb7c ph\u1ea7n tr\u0103m, h\u00e3y g\u00f5 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 trong \u00f4 <strong>Value<\/strong> ho\u1eb7c nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng c\u1eeda s\u1ed5 thu g\u1ecdn \u0111\u1ec3 ch\u1ecdn m\u1ed9t \u00f4, nh\u01b0 th\u1ec3 hi\u1ec7n trong h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ul>\n<p><strong>Xem th\u00eam<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-excel\">th\u1ee7 thu\u1eadt excel n\u00e2ng cao<\/a> hay nh\u00e2\u0301t mo\u0323i th\u01a1\u0300i \u0111a\u0323i<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-126.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4877 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-126.bmp\" width=\"600\" height=\"726\" title=\"new-bitmap-image-2-126\"><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_ap_dung_mot_tap_hop_bieu_tuong_Excel_dua_tren_gia_tri_cua_cac_o\"><\/span><strong>C\u00e1ch \u00e1p d\u1ee5ng m\u1ed9t t\u1eadp h\u1ee3p bi\u1ec3u t\u01b0\u1ee3ng Excel d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4<\/strong>:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1ed9t \u00fd ki\u1ebfn \u200b\u200bchung l\u00e0 c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng trong \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel ch\u1ec9 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a ch\u00ednh ch\u00fang. Nh\u01b0ng \u0111\u00e2y l\u00e0 m\u1ed9t \u00fd t\u01b0\u1edfng sai. V\u1edbi ch\u1ec9 m\u1ed9t ch\u00fat s\u00e1ng t\u1ea1o, b\u1ea1n c\u00f3 th\u1ec3 g\u00e1n c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng t\u00f9y thu\u1ed9c v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4 kh\u00e1c trong m\u1ed9t h\u00e0ng ho\u1eb7c d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 kh\u00e1c, nh\u01b0 th\u1ec3 hi\u1ec7n trong c\u00e1c v\u00ed d\u1ee5 sau \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><a href=\"https:\/\/goo.gl\/kmBmz7\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7076 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101-2.png\" width=\"851\" height=\"315\" title=\"ex101-2\"><\/a><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 1. \u00c1p d\u1ee5ng m\u1ed9t b\u1ed9 bi\u1ec3u t\u01b0\u1ee3ng d\u1ef1a tr\u00ean c\u00e1c \u00f4 kh\u00e1c trong m\u1ed9t h\u00e0ng (kho\u1ea3ng tr\u1ed1ng v\u00e0 kh\u00f4ng kho\u1ea3ng tr\u1ed1ng)<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c s\u1ea3n ph\u1ea9m bao g\u1ed3m h\u00e0ng trong kho, h\u00e0ng \u0111i giao v\u00e0 c\u00e1c chi ti\u1ebft kh\u00e1c. Nh\u1eefng g\u00ec b\u1ea1n mu\u1ed1n l\u00e0 th\u00eam c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng kh\u00e1c nhau v\u00e0o \u0111\u1ea7u m\u1ed7i h\u00e0ng ph\u1ee5 thu\u1ed9c v\u00e0o vi\u1ec7c c\u00e1c \u00f4 trong c\u00f9ng m\u1ed9t h\u00e0ng tr\u1ed1ng hay kh\u00f4ng. Ngh\u0129a l\u00e0 b\u1ea1n s\u1ebd th\u00eam \u0111\u00e1nh d\u1ea5u v\u00e0o C\u1ed9t A n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong m\u1ed9t h\u00e0ng c\u00f3 d\u1eef li\u1ec7u, d\u1ea5u ch\u1ea5m than n\u1ebfu m\u1ed9t s\u1ed1 \u00f4 tr\u1ed1ng, v\u00e0 bi\u1ec3u t\u01b0\u1ee3ng ch\u00e9o n\u1ebfu t\u1ea5t c\u1ea3 \u00f4 trong m\u1ed9t h\u00e0ng tr\u1ed1ng. \u0110\u1ec3 s\u1eed d\u1ee5ng bi\u1ec3u t\u01b0\u1ee3ng Excel \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp theo c\u00e1ch n\u00e0y, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Th\u00eam m\u1ed9t c\u1ed9t tr\u1ed1ng \u1edf ph\u00eda tr\u01b0\u1edbc b\u1ea3ng c\u1ee7a b\u1ea1n (C\u1ed9t A).<\/li>\n<li>Sao ch\u00e9p c\u00f4ng th\u1ee9c sau tr\u00ean C\u1ed9t A: <strong>= COUNTBLANK (B2: F2)<\/strong>, trong \u0111\u00f3 F l\u00e0 c\u1ed9t cu\u1ed1i c\u00f9ng trong b\u1ea3ng c\u1ee7a b\u1ea1n. C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng trong m\u1ed7i h\u00e0ng.<\/li>\n<li>\u00c1p d\u1ee5ng quy t\u1eafc \u0111\u1eb7t bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho C\u1ed9t A b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o <strong>More Rules\u2026<\/strong>, nh\u01b0 \u0111\u00e3 gi\u1ea3i th\u00edch \u1edf tr\u00ean.<\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <strong>New Formatting Rule<\/strong> , h\u00e3y l\u00e0m nh\u01b0 sau:<\/li>\n<\/ol>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5p v\u00e0o n\u00fat <strong>Reverse Icon Order<\/strong> \u0111\u1ec3 thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng.<\/li>\n<li>\u0110\u00e1nh d\u1ea5u h\u1ed9p <strong>Show Icon Only<\/strong>.<\/li>\n<li>\u0110\u1ed1i v\u1edbi bi\u1ec3u t\u01b0\u1ee3ng <strong>\u201cX\u201d<\/strong>, \u0111\u1eb7t&gt; = 5 (trong \u0111\u00f3 5 l\u00e0 s\u1ed1 c\u1ed9t trong b\u1ea3ng c\u1ee7a b\u1ea1n, ngo\u1ea1i tr\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean).<\/li>\n<li>\u0110\u1ed1i v\u1edbi bi\u1ec3u t\u01b0\u1ee3ng <strong>\u201c!\u201d<\/strong>, \u0111\u1eb7t&gt; = 1.<\/li>\n<li>\u0110\u1eb7t <strong>Type<\/strong> th\u00e0nh <strong>Number<\/strong> cho c\u1ea3 hai bi\u1ec3u t\u01b0\u1ee3ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 x\u00e1c minh c\u00e1c c\u00e0i \u0111\u1eb7t trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-127.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4878 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-127.bmp\" width=\"565\" height=\"458\" title=\"new-bitmap-image-2-127\"><\/a><\/p>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-128.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4879 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-128.bmp\" width=\"632\" height=\"182\" title=\"new-bitmap-image-2-128\"><\/a><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Ti\u0300m hi\u00ea\u0309u ngay:\u00a0\u00a0<span data-sheets-value='{\"1\":2,\"2\":\"kh\u00f3a h\u1ecdc excel n\u00e2ng cao H\u00e0 N\u1ed9i \"}' data-sheets-userformat='{\"2\":2561,\"3\":[null,0],\"12\":0,\"14\":[null,2,16711680]}'>kh\u00f3a h\u1ecdc excel n\u00e2ng cao H\u00e0 N\u1ed9i <\/span><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 2. Th\u00eam c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 kh\u00e1c<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch \u0111\u01a1n \u0111\u1eb7t h\u00e0ng v\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i th\u00eam c\u1edd m\u00e0u xanh l\u00e1 c\u00e2y v\u00e0o c\u1ed9t A khi m\u1ed9t s\u1ea3n ph\u1ea9m nh\u1ea5t \u0111\u1ecbnh \u0111\u01b0\u1ee3c giao, ngh\u0129a l\u00e0 c\u00f3 b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o trong \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t D (Ng\u00e0y giao h\u00e0ng). N\u1ebfu kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb trong c\u1ed9t D, c\u1edd \u0111\u1ecf s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t trong c\u1ed9t A.<\/p>\n<p style=\"text-align: justify\">Th\u1ef1c t\u1ebf, v\u00ed d\u1ee5 n\u00e0y r\u1ea5t gi\u1ed1ng v\u1edbi v\u00ed d\u1ee5 tr\u01b0\u1edbc, ch\u1ec9 kh\u00e1c l\u00e0 b\u1ea1n d\u00f9ng m\u1ed9t t\u1eadp h\u1ee3p 2-icon d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb trong m\u1ed9t c\u1ed9t kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">1. V\u00e0 m\u1ed9t l\u1ea7n n\u1eefa, b\u1ea1n b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch th\u00eam m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o c\u1ed9t A. L\u1ea7n n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m IF: <strong>= IF ($ D2 &lt;&gt; \u201d \u201c, 3,1)<\/strong>. C\u00f4ng th\u1ee9c cho bi\u1ebft \u0111\u1eb7t 3 trong c\u1ed9t A n\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o trong \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t D, n\u1ebfu kh\u00f4ng th\u00ec \u0111\u1eb7t 1. \u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i thay th\u1ebf D b\u1eb1ng c\u1ed9t b\u1ea1n d\u00f9ng l\u00e0m c\u0103n c\u1ee9 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-129.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4880 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-129.bmp\" width=\"458\" height=\"230\" title=\"new-bitmap-image-2-129\"><\/a><\/p>\n<p style=\"text-align: justify\">2. Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong c\u1ed9t A, ngo\u1ea1i tr\u1eeb ti\u00eau \u0111\u1ec1 c\u1ed9t v\u00e0 t\u1ea1o quy t\u1eafc \u0111\u1eb7t bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o <strong>Conditional Formatting&gt;Icon sets&gt;More rules\u2026 <\/strong><\/p>\n<p style=\"text-align: justify\">3. Trong h\u1ed9p tho\u1ea1i <strong>New <\/strong><strong>Formatting Rule<\/strong>, h\u00e3y ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5p v\u00e0o n\u00fat <strong>Reverse Icon Order<\/strong> \u0111\u1ec3 thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng.<\/li>\n<li>Ch\u1ecdn h\u1ed9p ki\u1ec3m <strong>Icon Set Only<\/strong>.<\/li>\n<li>\u0110\u1ed1i v\u1edbi l\u00e1 c\u1edd xanh, \u0111\u1eb7t&gt; = 3.<\/li>\n<li>\u0110\u1ed1i v\u1edbi c\u1edd m\u00e0u v\u00e0ng, \u0111\u1eb7t&gt; 2. Nh\u01b0 b\u1ea1n nh\u1edb, ta kh\u00f4ng c\u00f3 m\u1ed9t l\u00e1 c\u1edd m\u00e0u v\u00e0ng \u1edf b\u1ea5t c\u1ee9 \u0111\u00e2u, v\u00ec v\u1eady b\u1ea1n h\u00e3y \u0111\u1eb7t m\u1ed9t \u0111i\u1ec1u ki\u1ec7n m\u00e0 s\u1ebd kh\u00f4ng bao gi\u1edd \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 2 v\u00e0 nh\u1ecf h\u01a1n 3.<\/li>\n<li>\u0110\u1eb7t <strong>Type<\/strong> th\u00e0nh \u201c<strong>Number<\/strong>\u201d cho c\u1ea3 hai bi\u1ec3u t\u01b0\u1ee3ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-130.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4881 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-130.bmp\" width=\"564\" height=\"457\" title=\"new-bitmap-image-2-130\"><\/a><\/p>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 cho n\u1ed7 l\u1ef1c c\u1ee7a b\u1ea1n \u2013 c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng l\u00e1 c\u1edd m\u00e0u xanh l\u1ee5c v\u00e0 \u0111\u1ecf \u0111\u01b0\u1ee3c th\u00eam v\u00e0o c\u1ed9t A d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb trong c\u1ed9t D.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-131.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4882 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-131.bmp\" width=\"600\" height=\"166\" title=\"new-bitmap-image-2-131\"><\/a><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Ti\u0300m hi\u00ea\u0309u th\u00eam: B\u00f4\u0323 ta\u0300i li\u00ea\u0323u\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">h\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a> hay nh\u00e2\u0301t<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_co_dieu_kien_Data_Bars\"><\/span><strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Data Bars<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n <strong>Data Bars<\/strong> \u0111\u1ec3 bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u b\u00ean trong m\u1ed9t \u00f4. Thanh d\u00e0i nh\u1ea5t th\u1ec3 hi\u1ec7n gi\u00e1 tr\u1ecb cao nh\u1ea5t, v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u0111o\u00e1n, c\u00e1c thanh ng\u1eafn h\u01a1n th\u1ec3 hi\u1ec7n c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n. C\u00e1c thanh d\u1eef li\u1ec7u c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n nh\u1eadn th\u1ea5y s\u1ed1 l\u1edbn v\u00e0 s\u1ed1 nh\u1ecf trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n, v\u00ed d\u1ee5 nh\u01b0 c\u00e1c s\u1ea3n ph\u1ea9m b\u00e1n nhi\u1ec1u nh\u1ea5t v\u00e0 \u00edt nh\u1ea5t trong b\u00e1o c\u00e1o b\u00e1n h\u00e0ng c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n \u00e1p d\u1ee5ng thanh d\u1eef li\u1ec7u trong Excel theo c\u00e1ch \u0111\u00e3 quen thu\u1ed9c \u2013 ch\u1ec9 c\u1ea7n ch\u1ecdn c\u00e1c \u00f4, b\u1ea5m <strong>Conditional Formatting&gt;Data Bars<\/strong> v\u00e0 ch\u1ecdn lo\u1ea1i thanh b\u1ea1n mu\u1ed1n. M\u1ed9t khi b\u1ea1n l\u00e0m \u0111i\u1ec1u n\u00e0y, thanh m\u00e0u s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t b\u00ean trong c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-132.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4883 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-132.bmp\" width=\"558\" height=\"397\" title=\"new-bitmap-image-2-132\"><\/a><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, thanh d\u1eef li\u1ec7u \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n ho\u1ea1t \u0111\u1ed9ng r\u1ea5t t\u1ed1t \u0111\u1ec3 hi\u1ec3n th\u1ecb tr\u1ef1c quan c\u00e1c kho\u1ea3n chi ti\u00eau gia \u0111\u00ecnh c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng ki\u1ec3u thanh d\u1eef li\u1ec7u c\u1ee7a ri\u00eang b\u1ea1n, h\u00e3y nh\u1ea5p v\u00e0o <strong>More Rules\u2026 <\/strong>nh\u01b0 th\u01b0\u1eddng l\u1ec7 \u0111\u1ec3 g\u1ecdi c\u1eeda s\u1ed5 <strong>Edit Formatting Rule<\/strong>, n\u01a1i b\u1ea1n ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1eb7t d\u1ea5u ki\u1ec3m tra v\u00e0o \u00f4 <strong>Show Bar Only<\/strong> \u0111\u1ec3 \u1ea9n gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4 v\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb thanh m\u00e0u.<\/li>\n<li>\u0110\u1ec3 ch\u1ecdn lo\u1ea1i d\u1eef li\u1ec7u Minimum v\u00e0 Maximum, nh\u1ea5p v\u00e0o m\u0169i t\u00ean m\u00e0u \u0111en nh\u1ecf b\u00ean c\u1ea1nh h\u1ed9p t\u01b0\u01a1ng \u1ee9ng. M\u1eb7c d\u00f9 ki\u1ec3u Automatic ho\u1ea1t \u0111\u1ed9ng t\u1ed1t trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t s\u1ed1 lo\u1ea1i d\u1eef li\u1ec7u kh\u00e1c nh\u01b0 ph\u1ea7n tr\u0103m, s\u1ed1, c\u00f4ng th\u1ee9c, v.v.<\/li>\n<li>Th\u1eed nghi\u1ec7m v\u1edbi m\u00e0u n\u1ec1n, khung vi\u1ec1n v\u00e0 h\u01b0\u1edbng thanh v\u00e0 nh\u1ea5p OK khi b\u1ea1n h\u00e0i l\u00f2ng v\u1edbi <strong>Data Bar Preview.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-133.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4884 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-133.bmp\" width=\"594\" height=\"512\" title=\"new-bitmap-image-2-133\"><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_co_dieu_kien_Color_Scales\"><\/span><strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Color Scales<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<strong> Color Scales<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng \u00f4 c\u1ee7a m\u00ecnh v\u1edbi hai ho\u1eb7c ba m\u00e0u theo thang, trong \u0111\u00f3 c\u00e1c m\u00e0u s\u1eafc kh\u00e1c nhau \u0111\u1ea1i di\u1ec7n cho c\u00e1c gi\u00e1 tr\u1ecb \u00f4 kh\u00e1c nhau.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch nh\u1ea5p <strong>Conditional Formatting&gt;Color Scales<\/strong> v\u00e0 di chu\u1ed9t qua h\u00ecnh thu nh\u1ecf c\u1ee7a c\u00e1c thang m\u00e0u s\u1eb5n c\u00f3 Excel \u0111\u00e3 t\u1ea1o cho b\u1ea1n. Hai m\u00e0u xanh l\u00e1 c\u00e2y v\u00e0 tr\u1eafng d\u01b0\u1eddng nh\u01b0 kh\u00e1 \u0111\u1eb9p cho ng\u00e2n s\u00e1ch gia \u0111\u00ecnhi:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-134.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4885 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-134.bmp\" width=\"600\" height=\"389\" title=\"new-bitmap-image-2-134\"><\/a><\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng n\u1ebfu b\u1ea1n th\u1ef1c s\u1ef1 mu\u1ed1n g\u00e2y \u1ea5n t\u01b0\u1ee3ng v\u1edbi ai \u0111\u00f3, c\u00f3 th\u1eddi gian v\u00e0 mong mu\u1ed1n th\u1eed nghi\u1ec7m, h\u00e3y th\u1eed l\u1ea1i More Rules\u2026 v\u00e0 tr\u1ea3i nghi\u1ec7m v\u1edbi m\u00e0u s\u1eafc m\u1ed9t ch\u00fat. Tr\u01b0\u1edbc h\u1ebft, b\u1ea1n ch\u1ecdn thang \u0111o 2 m\u00e0u ho\u1eb7c 3 m\u00e0u, sau \u0111\u00f3 ch\u1ecdn m\u00e0u c\u1ee7a ri\u00eang b\u1ea1n v\u00e0 ch\u1ec9 \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb t\u1ed1i thi\u1ec3u, t\u1ed1i \u0111a, v\u00e0 trung b\u00ecnh.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-135.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4887 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-135.bmp\" width=\"600\" height=\"415\" title=\"new-bitmap-image-2-135\"><\/a><\/p>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel t\u1ea1i nh\u00e0<\/a> Online 1 th\u00e2\u0300y 1 tro\u0300<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-320.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7842,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7841","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7841","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=7841"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7841\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7842"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}