{"id":6680,"date":"2024-12-21T15:54:28","date_gmt":"2024-12-21T15:54:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-de-danh-dau-gia-tri-lon-nhat-nho-nhat-trong-moi-hang-hoac-cot\/"},"modified":"2024-12-21T15:54:28","modified_gmt":"2024-12-21T15:54:28","slug":"cach-de-danh-dau-gia-tri-lon-nhat-nho-nhat-trong-moi-hang-hoac-cot","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-de-danh-dau-gia-tri-lon-nhat-nho-nhat-trong-moi-hang-hoac-cot\/","title":{"rendered":"C\u00e1ch \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t\/nh\u1ecf nh\u1ea5t trong m\u1ed7i h\u00e0ng ho\u1eb7c c\u1ed9t"},"content":{"rendered":"
\n

N\u1ebfu b\u1ea1n c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u, l\u00e0m c\u00e1ch n\u00e0o b\u1ea1n \u0111\u00e1nh d\u1ea5u \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ho\u1eb7c nh\u1ecf nh\u1ea5t trong m\u1ed7i h\u00e0ng ho\u1eb7c c\u1ed9t? S\u1ebd m\u1ea5t nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 b\u1ea1n x\u00e1c \u0111\u1ecbnh ch\u00fang, v\u00ec v\u1eady trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch th\u1ef1c hi\u1ec7n \u0111i\u1ec1u \u0111\u00f3 b\u1eb1ng t\u00ednh n\u0103ng Conditional Formatting trong Excel.<\/p>\n

\u0110\u00e1nh d\u1ea5u gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t\/nh\u1ecf nh\u1ea5t \u1edf m\u1ed7i h\u00e0ng ho\u1eb7c c\u1ed9t<\/strong><\/h2>\n

\u0110\u1ec3 l\u00e0m gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ho\u1eb7c nh\u1ecf nh\u1ea5t n\u1ed5i b\u1eadt \u1edf m\u1ed7i h\u00e0ng, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a m\u1ed7i h\u00e0ng.<\/p>\n

2. Nh\u1ea5p Home<\/strong> > Conditional Formatting<\/strong> > New Rule<\/strong><\/p>\n

\"doc-highlight-largest-each-row-1\"<\/p>\n

3. Trong h\u1ed9p tho\u1ea1i New Formatting Rule<\/strong>, ch\u1ecdn Use a formula to determine which cells to format<\/strong> t\u1eeb danh s\u00e1ch Select a Rule Type<\/strong>, sau \u0111\u00f3 nh\u1eadp c\u00f4ng th\u1ee9c sau =B2=MAX($B2:$E2)<\/strong> v\u00e0o h\u1ed9p Format values where this formula is true<\/strong>, nh\u01b0 h\u00ecnh:<\/p>\n

M\u1eb9o: <\/strong>Trong c\u00f4ng th\u1ee9c tr\u00ean, B2 \u0111\u01b0\u1ee3c coi l\u00e0 d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng ch\u1ecdn, B2:E2 l\u00e0 d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng ch\u1ecdn m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t. B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i ch\u00fang theo nhu c\u1ea7u.<\/p>\n

<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

4. Sau \u0111\u00f3 ch\u1ecdn Format, <\/strong>trong h\u1ed9p tho\u1ea1i Format Cells<\/strong>, ch\u1ecdn m\u00e0u b\u1ea1n th\u00edch trong tab Fill<\/strong>.<\/p>\n

\"doc-highlight-largest-each-row-1\"<\/p>\n

5. Nh\u1ea5n OK \u0111\u1ebfn khi \u0111\u00f3ng h\u1ed9p tho\u1ea1i, v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a m\u1ed7i h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u m\u00e0u.<\/p>\n

L\u01b0u \u00fd:<\/strong><\/p>\n

1. N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t c\u1ee7a h\u00e0ng, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c =B2=MIN($B2:$E2)<\/strong> trong b\u01b0\u1edbc 3.<\/p>\n

2. C\u00f4ng c\u1ee5 Conditional Formatting r\u1ea5t linh ho\u1ea1t, \u00f4 m\u00e0u s\u1ebd \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh n\u1ebfu c\u00f3 thay \u0111\u1ed5i gi\u00e1 tr\u1ecb trong ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn.<\/p>\n

3. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u0111\u00e1nh d\u1ea5u m\u00e0u gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t cho c\u1ed9t. H\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c =B2=MAX(B$2:B$10)<\/strong> ho\u1eb7c =B2=MIN(B$2:B$10) <\/strong>l\u1ea7n l\u01b0\u1ee3t cho gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 b\u00e9 nh\u1ea5t. (Trong c\u00f4ng th\u1ee9c tr\u00ean, B2 \u0111\u01b0\u1ee3c coi l\u00e0 d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng ch\u1ecdn, B2:E2 l\u00e0 d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng ch\u1ecdn m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t. B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i ch\u00fang theo nhu c\u1ea7u.)<\/p>\n

\"doc-highlight-largest-each-row-1\"<\/p>\n

C\u00f3 r\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1ec1 Excel ph\u1ea3i kh\u00f4ng n\u00e0o? 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\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/a><\/p>\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":6681,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6680","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\/6680","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=6680"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6680\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6681"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}