{"id":11971,"date":"2024-03-04T02:50:25","date_gmt":"2024-03-03T19:50:25","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11971"},"modified":"2025-04-15T16:43:56","modified_gmt":"2025-04-15T09:43:56","slug":"cach-to-mau-co-dieu-kien","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11971&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4\\\/5 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel&quot;,&quot;width&quot;:&quot;113.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 113.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4\/5 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400;\">C\u00e1ch<\/span><b> t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft t\u1ed1t nh\u1ea5t cho v\u1ea5n \u0111\u1ec1 b\u1ea1n \u0111ang lo l\u1eafng. Khi c\u00f3 qu\u00e1 nhi\u1ec1u n\u1ed9i dung tr\u00f9ng nhau v\u1ec1 \u00fd. B\u1ea1n mu\u1ed1n l\u00e0m b\u1eadt l\u00ean nh\u1eefng \u00f4 d\u1eef li\u1ec7u c\u0169ng nh\u01b0 mu\u1ed1n nh\u1ea5n m\u1ea1nh n\u1ed9i dung \u0111\u00e1ng \u0111\u01b0\u1ee3c ch\u00fa \u00fd. V\u1eady th\u00ec b\u00e0i vi\u1ebft n\u00e0y s\u1ebd c\u1ea7n b\u1ea1n \u0111\u1ecdc k\u0129 nh\u1ea5t \u0111\u1ec3 c\u00f3 th\u00eam th\u00f4ng tin v\u1ec1 c\u00e1ch<\/span><b> t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<\/b><span style=\"font-weight: 400;\">. \u0110\u1ea3m b\u1ea3o b\u00e0i vi\u1ebft n\u00e0y s\u1ebd kh\u00f4ng u\u1ed5ng ph\u00ed th\u1eddi gian m\u00e0 b\u1ea1n d\u00e0nh ra \u0111\u1ec3 \u0111\u1ecdc!\u00a0<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#O_co_dinh_dang_mau_co_dieu_kien_la_nhu_the_nao\" >\u00d4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n l\u00e0 nh\u01b0 th\u1ebf n\u00e0o?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#Cach_su_dung_Conditional_Formatting_de_to_mau_co_dieu_kien_trong_Excel\" >C\u00e1ch s\u1eed d\u1ee5ng Conditional Formatting \u0111\u1ec3 t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#Dinh_nghia_ve_Conditional_Formatting\" >\u0110\u1ecbnh ngh\u0129a v\u1ec1 Conditional Formatting.\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#Huong_dan_chi_tiet\" >H\u01b0\u1edbng d\u1eabn chi ti\u1ebft<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#Huong_dan_cach_dinh_dang_co_dieu_kien_danh_cho_o_trong\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u00e0nh cho \u00f4 tr\u1ed1ng<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#Mot_vi_du_co_ban_ve_to_mau_co_dieu_kien_trong_excel\" >M\u1ed9t v\u00ed d\u1ee5 c\u01a1 b\u1ea3n v\u1ec1 t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel.<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"O_co_dinh_dang_mau_co_dieu_kien_la_nhu_the_nao\"><\/span><span style=\"font-weight: 400;\">\u00d4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n l\u00e0 nh\u01b0 th\u1ebf n\u00e0o?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ecbnh d\u1ea1ng <\/span><b>t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel <\/b><span style=\"font-weight: 400;\">l\u00e0 b\u1ea1n c\u00f3 \u00fd \u0111\u1ecbnh ho\u1eb7c mu\u1ed1n l\u00e0m thay \u0111\u1ed5i \u00f4 m\u00e0u m\u1eb7c \u0111\u1ecbnh ban \u0111\u1ea7u. V\u00ec n\u1ed9i dung \u0111\u01b0\u1ee3c \u0111\u1eb7t trong \u00f4 c\u00f3 nhi\u1ec1u \u00fd ngh\u0129a c\u0169ng nh\u01b0 gi\u00e1 tr\u1ecb \u0111\u1eb7c bi\u1ec7t. V\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i m\u00e0u \u00f4 \u0111\u1ec3 \u0111\u01b0\u1ee3c ch\u00fa \u00fd so v\u1edbi c\u00e1c \u00f4 c\u00f2n l\u1ea1i.\u00a0<\/span><\/p>\n<p><a href=\"http:\/\/hoclaptrinhmienphi.teky.vn\/1hhoclaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24877\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Banner-Free-Trial.png\" alt=\"H\u1ecdc th\u1eed mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c \u00f4 m\u00e0u \u0111\u1ecf khi nh\u1eadp ch\u1eef \u201cYes\u201d. Nh\u01b0ng n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n sang h\u1ed3ng khi b\u1ea1n b\u1eaft \u0111\u1ea7u thay \u0111\u1ed5i th\u00e0nh t\u1eeb \u201cNo\u201d. \u00dd ngh\u0129a c\u1ee7a vi\u1ec7c n\u00e0y s\u1ebd ki\u1ec3m so\u00e1t c\u1ef1c t\u1ed1t c\u00e1c d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n tr\u00ecnh b\u00e0y. \u0110\u1eb7c bi\u1ec7t l\u00e0 s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t v\u00e0 h\u00e0ng l\u00ean \u0111\u1ebfn h\u00e0ng tr\u0103m, h\u00e0ng ngh\u00ecn th\u00ec\u00a0 ki\u1ec3m so\u00e1t l\u00e0 c\u1ef1c k\u00ec kh\u00f3. Do \u0111\u00f3 <\/span><b>t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel <\/b><span style=\"font-weight: 400;\">s\u1ebd l\u00e0 c\u00f4ng c\u1ee5 l\u1ee3i h\u1ea1i gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft \u0111i\u1ec1u \u0111\u00f3.<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cong-thuc-trong-excel\/\"><em><strong><span style=\"color: #0000ff;\">C\u00e1ch \u1ea9n c\u00f4ng th\u1ee9c trong Excel<\/span><\/strong><\/em><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_Conditional_Formatting_de_to_mau_co_dieu_kien_trong_Excel\"><\/span><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng Conditional Formatting \u0111\u1ec3 t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_nghia_ve_Conditional_Formatting\"><\/span><span style=\"font-weight: 400;\">\u0110\u1ecbnh ngh\u0129a v\u1ec1 Conditional Formatting.\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">V\u1edbi t\u1eeb conditional formatting \u0111\u01b0\u1ee3c d\u1ecbch ra v\u1edbi ngh\u0129a l\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ea3 v\u1ec1 c\u00e1c th\u1ee9. Ch\u1eb3ng h\u1ea1n nh\u01b0 \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh l\u00e0m thay \u0111\u1ed5i font c\u1ee7a t\u1eeb ng\u1eef, k\u00edch th\u01b0\u1edbc ch\u1eef, k\u1ec3 c\u1ea3 m\u00e0u c\u1ee7a \u00f4 v\u00e0 ch\u1eef \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp\u2026 Do \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 ho\u00e0n to\u00e0n y\u00ean t\u00e2m \u0111\u1ea3m b\u1ea3o \u0111\u01b0\u1ee3c vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y \u0111\u1ec3 t\u00f4 m\u00e0u \u00f4 c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Huong_dan_chi_tiet\"><\/span><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn chi ti\u1ebft<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 1<\/strong>: Gi\u1ed1ng nh\u01b0 nh\u1eefng thao t\u00e1c kh\u00e1c khi mu\u1ed1n l\u00e0m thay \u0111\u1ed5i g\u00ec trong excel. Th\u00ec ta s\u1ebd \u0111\u1ea7u ti\u00ean l\u00e0 b\u00f4i \u0111en to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh m\u00e0 ta \u0111ang l\u00e0m vi\u1ec7c. Ch\u1ecdn Conditional Formatting tr\u00ean th\u1ebb c\u1ee7a Home.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11972 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-18.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-18.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-18-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-18-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 2<\/strong>: Ti\u1ebfp theo ta s\u1ebd ti\u1ebfp t\u1ee5c ch\u1ecdn New Rule.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11973 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-17.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-17.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-17-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-17-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 3<\/strong>: Khi b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 ra k\u1ebft qu\u1ea3 nh\u01b0 mong mu\u1ed1n. C\u1ea7n l\u1ef1a ch\u1ecdn k\u0129 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 t\u00f4 m\u00e0u trong ph\u1ea7n m\u1ee5c Select a Rule Type.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11974 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-18.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-18.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-18-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-18-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 c\u00f3 th\u1ec3 tham kh\u1ea3o v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a ch\u00fang t\u00f4i. \u0110\u00e2y l\u00e0 h\u00e0m s\u1eed d\u1ee5ng \u0111\u1ec3 c\u00e1c m\u00e0u \u0111\u01b0\u1ee3c t\u00f4 xen k\u1ebd v\u1edbi nhau qua c\u00e1c d\u00f2ng. Do \u0111\u00f3, khi ph\u1ea7n Select a Rule Type ta s\u1ebd nh\u1ea5n ch\u1ecdn Use a formula to determine which cells to format. Khi \u0111\u00f3, ta ch\u1ecdn ti\u1ebfp ph\u1ea7n Format values where this formula is true. S\u1ebd ti\u1ebfp t\u1ee5c nh\u1eadp h\u00e0m c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m sau: <\/span><span style=\"font-weight: 400;\">= MOD(ROW();2)&gt;0.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11975 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-17.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-17.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-17-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-17-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 4<\/strong>: ch\u1ecdn nh\u1ea5n\u00a0 Format\u2026<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11977 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-16.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-16.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-16-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-16-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 5<\/strong>: Khi \u0111\u00f3, b\u1ea3ng ch\u1ecdn v\u1edbi t\u00ean Format Cells \u0111\u01b0\u1ee3c hi\u1ec7n l\u00ean v\u1edbi c\u00e1c th\u00f4ng tin:\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\"><strong>Numbe<\/strong>r: Nh\u1eefng \u00f4 l\u00e0 ng\u00e0y th\u00e1ng n\u0103m hay l\u00e0 s\u1ed1 ch\u1eb3ng h\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c b\u1ea1n ch\u1ecdn \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng\u2026<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>Font<\/strong>: \u00d4 n\u00e0y d\u00e0nh cho b\u1ea1n khi mu\u1ed1n \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng c\u00e1c ki\u1ec3u ch\u1eef, ch\u1ec9nh s\u1eeda k\u00edch th\u01b0\u1edbc c\u1ee7a ch\u1eef\u2026\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/lotrinhlaptrinh.teky.vn\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24875\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Sale-Promotion.png\" alt=\"\u01afu \u0111\u00e3i \u0111\u1ebfn 25%\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\"><strong>Border<\/strong>: Khi b\u1ea1n mu\u1ed1n vi\u1ec1n \u0111\u01b0\u1ee3c k\u1ebb theo \u00fd mu\u1ed1n c\u1ee7a m\u00ecnh th\u00ec b\u1ea1n n\u00ean th\u1ebb n\u00e0y.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>Fill<\/strong>: \u0110\u00e2y l\u00e0 th\u1ebb b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u. Trong \u0111i\u1ec1u ki\u1ec7n n\u00e0y, b\u1ea1n ch\u1ecdn m\u00e0u s\u1eafc theo \u00fd th\u00edch c\u1ee7a m\u00ecnh. V\u00e0 cu\u1ed1i c\u00f9ng ch\u1ecdn nh\u1ea5n OK \u0111\u1ec3 <\/span><b>t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u<\/b> <b>ki\u1ec7n trong excel <\/b><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c ho\u00e0n t\u1ea5t. L\u00fac n\u00e0y, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c excel \u0111\u01b0a quay l\u1ea1i v\u1edbi b\u1ea3ng \u0111\u1ec3 ch\u1ecdn v\u00e0 b\u1ea1n nh\u1ea5n New Formatting Rule. Nh\u1ea5n ch\u1ecdn cu\u1ed1i c\u00f9ng l\u00e0 ok.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11976 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-15.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-15.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-15-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-15-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c sau c\u00e1c b\u01b0\u1edbc l\u00e0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11979 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-12.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-12.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-12-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-12-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Huong_dan_cach_dinh_dang_co_dieu_kien_danh_cho_o_trong\"><\/span><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u00e0nh cho \u00f4 tr\u1ed1ng<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c \u00f4 b\u1ecb tr\u1ed1ng. Ta th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y \u0111\u1ec3 d\u1ec5 d\u00e0ng \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 b\u1ea1n mong mu\u1ed1n. Ta l\u1ea7n l\u01b0\u1ee3t nh\u1ea5n ch\u1ecdn \u201cFormat only cells that contain\u201d ti\u1ebfp t\u1ee5c ch\u1ecdn \u201cBlanks\u201d.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">M\u1eb7t kh\u00e1c, c\u00f3 nh\u1eefng \u00f4 m\u00e0 b\u1ea1n c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng c\u1ed9t \u1ee9ng v\u1edbi \u00f4 l\u00e0 tr\u1ed1ng ho\u1eb7c kh\u00f4ng tr\u1ed1ng. V\u1eady theo tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t n\u00e0y, b\u1ea1n c\u1ea7n c\u00f3 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c cho Excel \u0111\u1ec3 nh\u1eadp v\u00e0o.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u1edbi vi\u1ec7c d\u00e0nh cho kho\u1ea3ng tr\u1ed1ng th\u00ec c\u1ea7n c\u00f3 c\u00f4ng th\u1ee9c sau: =$B2=\u201d\u201d\u2013. <\/span><span style=\"font-weight: 400;\">\u0110\u1ecbnh d\u1ea1ng nh\u1eefng \u00f4 hay h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ea1n ch\u1ecdn n\u1ebfu c\u00f3 s\u1ef1 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B l\u00e0 tr\u1ed1ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u1edbi vi\u1ec7c d\u00e0nh cho kho\u1ea3ng kh\u00f4ng c\u00f3 tr\u1ed1ng th\u00ec c\u1ea7n c\u00f3 c\u00f4ng th\u1ee9c sau:=$B2&lt;&gt;\u201d -. \u0110\u1ecbnh d\u1ea1ng nh\u1eefng \u00f4 hay h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ea1n ch\u1ecdn n\u1ebfu c\u00f3 s\u1ef1 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B l\u00e0 kh\u00f4ng tr\u1ed1ng.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mot_vi_du_co_ban_ve_to_mau_co_dieu_kien_trong_excel\"><\/span><span style=\"font-weight: 400;\">M\u1ed9t v\u00ed d\u1ee5 c\u01a1 b\u1ea3n v\u1ec1 t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tuy v\u1ec1 v\u00ed d\u1ee5 <\/span><b>t\u00f4 m\u00e0u \u00f4 c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel <\/b><span style=\"font-weight: 400;\">c\u00f3 r\u1ea5t nhi\u1ec1u nh\u01b0ng l\u01b0\u1ee3ng th\u00f4ng tin c\u00f3 gi\u1edbi h\u1ea1n. N\u00ean b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t v\u00ed d\u1ee5 sau \u0111\u00e2y: H\u00e0m AND v\u00e0 OR<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Khi b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng <\/span>t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n n<span style=\"font-weight: 400;\">h\u01b0ng s\u1ed1 \u0111i\u1ec1u ki\u1ec7n l\u1ea1i b\u1eaft \u0111\u1ea7u t\u1eeb hai tr\u1edf l\u00ean. C\u00f4ng th\u1ee9c m\u00e0 ta \u00e1p d\u1ee5ng l\u00e0 h\u00e0m =AND ho\u1eb7c h\u00e0m =OR. \u0110\u00e2y s\u1ebd l\u00e0m c\u00f3 vai tr\u00f2 c\u1ef1c k\u1ef3 cao v\u00e0 h\u1ed7 tr\u1ee3 b\u1ea1n c\u1ef1c k\u00ec t\u1ed1t \u0111\u00f3. B\u00ean c\u1ea1nh \u0111\u00f3, c\u1ea3 hai h\u00e0m n\u00e0y \u0111\u1ec1u c\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho c\u1ea3 d\u00e0nh cho v\u0103n b\u1ea3n v\u00e0 ch\u1eef s\u1ed1.\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n vi\u1ec7c x\u1ea3y ra l\u00e0 \u0111\u1ed3ng th\u1eddi c\u1ee7a c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n th\u00ec \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=AND($B2&lt;$C2, $C2&lt;$D2).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f2n n\u1ebfu khi b\u1ea1n mu\u1ed1n vi\u1ec7c x\u1ea3y ra l\u00e0 m\u1ed9t trong hai \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0a ra th\u00ec ta \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c: =OR($B2&lt;$C2, $C2&lt;$D2).<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/khuyenmai.teky.vn\/tangsachlaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24876\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Free-Asset.png\" alt=\"T\u1eb7ng s\u00e1ch mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Minh h\u1ecda b\u1eb1ng v\u00ed d\u1ee5 sau \u0111\u00e2y: \u0110\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c vi\u1ec7c t\u00f4 m\u00e0u lo\u1ea1i h\u00e0ng h\u00f3a v\u1edbi s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 0 v\u00e0 \u0111\u01b0\u1ee3c mua ch\u00ednh th\u1ee9c t\u1ea1i \u1edf Hu\u1ebf, c\u00f4ng th\u1ee9c m\u00e0 ta \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng l\u00e0: <\/span><span style=\"font-weight: 400;\">=AND($C2&gt;0, $E2=\u201dHu\u1ebf\u201d.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11978 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-16.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-16.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-16-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-16-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Tr\u00ean b\u00e0i vi\u1ebft l\u00e0 t\u1ea5t c\u1ea3 nh\u1eefng th\u00f4ng tin t\u00f3m t\u1eaft v\u00f4 c\u00f9ng chi ti\u1ebft \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i t\u1ed5ng h\u1ee3p v\u1ec1 th\u00f4ng tin <\/span><b>t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<\/b><span style=\"font-weight: 400;\">. Hay b\u1ea1n mu\u1ed1n bi\u1ebft c\u00e1ch <\/span>t\u00f4 m\u00e0u \u00f4 c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<span style=\"font-weight: 400;\"> th\u00ec \u0111\u00e2y l\u00e0 b\u00e0i vi\u1ebft th\u1eadt s\u1ef1 h\u1eefu \u00edch. Hy v\u1ecdng b\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng h\u01a1n trong qu\u00e1 tr\u00ecnh thao t\u00e1c v\u1edbi excel.\u00a0<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/cung-tre-lap-trinh\/\"><span style=\"color: #0000ff;\"><b><i>C\u00f9ng tr\u1ebb l\u1eadp tr\u00ecnh\u00a0<\/i><\/b><\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel l\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft t\u1ed1t nh\u1ea5t cho v\u1ea5n \u0111\u1ec1 b\u1ea1n \u0111ang lo l\u1eafng. Khi c\u00f3 qu\u00e1 nhi\u1ec1u n\u1ed9i dung tr\u00f9ng nhau v\u1ec1 \u00fd. B\u1ea1n mu\u1ed1n l\u00e0m b\u1eadt l\u00ean nh\u1eefng \u00f4 d\u1eef li\u1ec7u c\u0169ng nh\u01b0 mu\u1ed1n nh\u1ea5n m\u1ea1nh n\u1ed9i dung \u0111\u00e1ng \u0111\u01b0\u1ee3c ch\u00fa \u00fd. V\u1eady th\u00ec b\u00e0i vi\u1ebft &hellip;<\/p>\n","protected":false},"author":26,"featured_media":11980,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11971","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<\/title>\n<meta name=\"description\" content=\"C\u00e1ch t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel l\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft t\u1ed1t nh\u1ea5t cho v\u1ea5n \u0111\u1ec1 b\u1ea1n \u0111ang lo l\u1eafng khi c\u00f3 qu\u00e1 nhi\u1ec1u n\u1ed9i dung tr\u00f9ng nhau v\u1ec1 \u00fd.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel l\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft t\u1ed1t nh\u1ea5t cho v\u1ea5n \u0111\u1ec1 b\u1ea1n \u0111ang lo l\u1eafng khi c\u00f3 qu\u00e1 nhi\u1ec1u n\u1ed9i dung tr\u00f9ng nhau v\u1ec1 \u00fd.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-03T19:50:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T09:43:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-9.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel\",\"datePublished\":\"2024-03-03T19:50:25+00:00\",\"dateModified\":\"2025-04-15T09:43:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/\"},\"wordCount\":1666,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-9.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-9.jpg\",\"datePublished\":\"2024-03-03T19:50:25+00:00\",\"dateModified\":\"2025-04-15T09:43:56+00:00\",\"description\":\"C\u00e1ch t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel l\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft t\u1ed1t nh\u1ea5t cho v\u1ea5n \u0111\u1ec1 b\u1ea1n \u0111ang lo l\u1eafng khi c\u00f3 qu\u00e1 nhi\u1ec1u n\u1ed9i dung tr\u00f9ng nhau v\u1ec1 \u00fd.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-9.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-9.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel","description":"C\u00e1ch t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel l\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft t\u1ed1t nh\u1ea5t cho v\u1ea5n \u0111\u1ec1 b\u1ea1n \u0111ang lo l\u1eafng khi c\u00f3 qu\u00e1 nhi\u1ec1u n\u1ed9i dung tr\u00f9ng nhau v\u1ec1 \u00fd.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel","og_description":"C\u00e1ch t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel l\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft t\u1ed1t nh\u1ea5t cho v\u1ea5n \u0111\u1ec1 b\u1ea1n \u0111ang lo l\u1eafng khi c\u00f3 qu\u00e1 nhi\u1ec1u n\u1ed9i dung tr\u00f9ng nhau v\u1ec1 \u00fd.","og_url":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2024-03-03T19:50:25+00:00","article_modified_time":"2025-04-15T09:43:56+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-9.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel","datePublished":"2024-03-03T19:50:25+00:00","dateModified":"2025-04-15T09:43:56+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/"},"wordCount":1666,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-9.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/","url":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/","name":"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-9.jpg","datePublished":"2024-03-03T19:50:25+00:00","dateModified":"2025-04-15T09:43:56+00:00","description":"C\u00e1ch t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel l\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft t\u1ed1t nh\u1ea5t cho v\u1ea5n \u0111\u1ec1 b\u1ea1n \u0111ang lo l\u1eafng khi c\u00f3 qu\u00e1 nhi\u1ec1u n\u1ed9i dung tr\u00f9ng nhau v\u1ec1 \u00fd.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-9.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-9.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-to-mau-co-dieu-kien\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11971","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11971"}],"version-history":[{"count":4,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11971\/revisions"}],"predecessor-version":[{"id":24958,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11971\/revisions\/24958"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11980"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}