{"id":11136,"date":"2025-01-15T01:44:24","date_gmt":"2025-01-15T01:44:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-ket-hop-mau-sac-cho-phu-hop-trong-bang-tinh-excel\/"},"modified":"2025-01-15T01:44:24","modified_gmt":"2025-01-15T01:44:24","slug":"cach-ket-hop-mau-sac-cho-phu-hop-trong-bang-tinh-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-ket-hop-mau-sac-cho-phu-hop-trong-bang-tinh-excel\/","title":{"rendered":"C\u00e1ch k\u1ebft h\u1ee3p m\u00e0u s\u1eafc cho ph\u00f9 h\u1ee3p trong b\u1ea3ng t\u00ednh Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Vi\u1ec7c <a href=\"http:\/\/blog.ezworkapp.com\/cach-ket-hop-mau-sac-phu-hop-trong-bang-tinh-excel.html\">k\u1ebft h\u1ee3p m\u00e0u s\u1eafc ph\u00f9 h\u1ee3p trong b\u1ea3ng t\u00ednh Excel<\/a> l\u00e0 c\u1ef1c k\u00ec quan tr\u1ecdng, vi\u1ec7c n\u00e0y s\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 \u0111\u1ecdc b\u1ea3ng t\u00ednh h\u01a1n v\u00e0 \u0111\u1ea1t hi\u1ec7u qu\u1ea3 cao h\u01a1n trong c\u00f4ng vi\u1ec7c. H\u00f4m nay, <a href=\"https:\/\/hocexcel.online\/\" target=\"_blank\">H\u1ecdc Excel Online<\/a> s\u1ebd gi\u1edbi thi\u1ec7u t\u1edbi b\u1ea1n hai c\u00f4ng th\u1ee9c \u0111\u1ec3 gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn \u0111\u01b0\u1ee3c m\u00e0u s\u1eafc ph\u00f9 h\u1ee3p v\u1edbi b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.<\/p>\n<p>C\u00f3 hai c\u00f4ng th\u1ee9c, v\u00e0 m\u1ed7i c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb:<\/p>\n<ul>\n<li>S\u1ef1 kh\u00e1c bi\u1ec7t v\u1ec1 \u0111\u1ed9 s\u00e1ng (Brightness Difference): gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 trong kho\u1ea3ng 0 \u0111\u1ebfn 255<\/li>\n<li>Kh\u00e1c bi\u1ec7t m\u00e0u s\u1eafc (Color Difference): tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trong kho\u1ea3ng 0 \u0111\u1ebfn 765<\/li>\n<\/ul>\n<p>Hai c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh <a href=\"http:\/\/blog.ezworkapp.com\/mot-ham-vba-thuong-dung.html\" target=\"_blank\">h\u00e0m VBA<\/a>, v\u00e0 hai c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n \u1edf c\u1ed9t B v\u00e0 C<\/p>\n<p>(\u2018Color sample\u2019: M\u00e0u s\u1eafc m\u1eabu<\/p>\n<p>\u2018This is sample text 123456789\u2019: \u0110\u00e2y l\u00e0 v\u0103n b\u1ea3n m\u1eabu 123456789<\/p>\n<p>\u2018Acceptable\u2019: Ch\u1ea5p nh\u1eadn<\/p>\n<p>\u2018No Good\u2019: Kh\u00f4ng \u1ed5n)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/colordifferencefunction.html\" width=\"496\" height=\"631\" title=\"colordifferencefunction\"><\/p>\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\/2025\/01\/ex101_92019-nho-261.gif\" title=\"ex101_92019-nho-261\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>S\u1ef1 k\u1ebft h\u1ee3p m\u00e0u s\u1eafc \u0111\u01b0\u1ee3c ch\u1ea5p nh\u1eadn ph\u1ea3i c\u00f3 \u0111i\u1ec3m kh\u00e1c bi\u1ec7t m\u00e0u s\u1eafc t\u1eeb 500 tr\u1edf l\u00ean, v\u00e0 kh\u00e1c bi\u1ec7t v\u1ec1 \u0111\u1ed9 s\u00e1ng ph\u1ea3i \u0111\u1ea1t 125 \u0111i\u1ec3m tr\u1edf l\u00ean.<\/p>\n<p>M\u1eb9o: Ch\u1eef tr\u1eafng n\u1ec1n \u0111en l\u00e0 l\u1ef1a ch\u1ecdn an to\u00e0n cho b\u1ea1n. H\u00e3y \u0111\u1ec3 d\u00e0nh nh\u1eefng m\u00e0u s\u1eafc \u1ea5n t\u01b0\u1ee3ng cho c\u1ed9t ti\u00eau \u0111\u1ec1ho\u1eb7c nh\u1eefng v\u00f9ng c\u1ea7n \u0111\u01b0\u1ee3c ch\u00fa \u00fd.<\/p>\n<p>\u00a0<\/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":"<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\/2025\/01\/ex101_92019-nho-261.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11137,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11136","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\/11136","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=11136"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11136\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11137"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}