{"id":7885,"date":"2024-12-21T18:45:21","date_gmt":"2024-12-21T18:45:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-dinh-dang-so-theo-ti-le-phan-tram-trong-excel\/"},"modified":"2024-12-21T18:45:21","modified_gmt":"2024-12-21T18:45:21","slug":"huong-dan-dinh-dang-so-theo-ti-le-phan-tram-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-dinh-dang-so-theo-ti-le-phan-tram-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn \u0111\u1ecbnh d\u1ea1ng s\u1ed1 theo t\u1ec9 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel"},"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, H\u1ecdc <a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao\">Excel n\u00e2ng cao<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m trong Excel, c\u00e1ch chuy\u1ec3n gi\u00e1 tr\u1ecb cho tr\u01b0\u1edbc th\u00e0nh ph\u1ea7n tr\u0103m, v\u00e0 c\u00e1ch th\u1ec3 hi\u1ec7n t\u1ec9 l\u1ec7 ph\u1ea7n tr\u0103m trong \u00f4 tr\u1ed1ng.<\/p>\n<p style=\"text-align: justify\">Trong Microsoft Excel, tr\u00ecnh b\u00e0y gi\u00e1 tr\u1ecb theo t\u1ec9 l\u1ec7 ph\u1ea7n tr\u0103m r\u1ea5t \u0111\u01a1n gi\u1ea3n. \u0110\u1ec3 \u00e1p d\u1ee5ng \u00a0\u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m cho m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4, h\u00e3y ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4, sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00fat <strong>Percent Style<\/strong> trong nh\u00f3m <strong>Number<\/strong> tr\u00ean tab <strong>Home<\/strong>:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-51.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4618 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-51.bmp\" width=\"276\" height=\"149\" title=\"new-bitmap-image-2-51\"><\/a><\/p>\n<p style=\"text-align: justify\">C\u00f3 m\u1ed9t c\u00e1ch nhanh h\u01a1n l\u00e0 nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + Shift + % (Excel s\u1ebd nh\u1eafc b\u1ea1n m\u1ed7i khi b\u1ea1n di chu\u1ed9t qua n\u00fat <em>Percent Style<\/em>).<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Ti\u0300m hi\u00ea\u0309u th\u00eam:\u00a0Kho\u0301a ho\u0323c Excel n\u00e2ng cao<\/p>\n<\/blockquote>\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-67670cc05e268\" 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-so-theo-ti-le-phan-tram-trong-excel.html#Dinh_dang_gia_tri_da_co_thanh_ty_le_phan_tram\" title=\"\u0110\u1ecbnh d\u1ea1ng gi\u00e1 tr\u1ecb \u0111\u00e3 c\u00f3 th\u00e0nh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m:\">\u0110\u1ecbnh d\u1ea1ng gi\u00e1 tr\u1ecb \u0111\u00e3 c\u00f3 th\u00e0nh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m:<\/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-so-theo-ti-le-phan-tram-trong-excel.html#Dung_dinh_dang_phan_tram_cho_o_trong\" title=\"D\u00f9ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m cho \u00f4 tr\u1ed1ng:\">D\u00f9ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m cho \u00f4 tr\u1ed1ng:<\/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-so-theo-ti-le-phan-tram-trong-excel.html#Hien_thi_so_phan_tram_theo_y_muon\" title=\"Hi\u1ec3n th\u1ecb s\u1ed1 ph\u1ea7n tr\u0103m theo \u00fd mu\u1ed1n:\">Hi\u1ec3n th\u1ecb s\u1ed1 ph\u1ea7n tr\u0103m theo \u00fd mu\u1ed1n:<\/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-so-theo-ti-le-phan-tram-trong-excel.html#Meo_de_hien_thi_phan_tram_trong_Excel\" title=\"M\u1eb9o \u0111\u1ec3 hi\u1ec3n th\u1ecb ph\u1ea7n tr\u0103m trong Excel\">M\u1eb9o \u0111\u1ec3 hi\u1ec3n th\u1ecb ph\u1ea7n tr\u0103m trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-dinh-dang-so-theo-ti-le-phan-tram-trong-excel.html#Hien_thi_phan_so_thap_phan\" title=\"Hi\u1ec3n th\u1ecb ph\u1ea7n s\u1ed1 th\u1eadp ph\u00e2n:\u00a0\">Hi\u1ec3n th\u1ecb ph\u1ea7n s\u1ed1 th\u1eadp ph\u00e2n:\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-dinh-dang-so-theo-ti-le-phan-tram-trong-excel.html#Thiet_lap_dinh_dang_cho_so_phan_tram_am\" title=\"Thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng cho s\u1ed1 ph\u1ea7n tr\u0103m \u00e2m:\">Thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng cho s\u1ed1 ph\u1ea7n tr\u0103m \u00e2m:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-dinh-dang-so-theo-ti-le-phan-tram-trong-excel.html#Dinh_dang_phan_tram_am_bang_Conditional_formatting_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m \u00e2m b\u1eb1ng Conditional formatting trong Excel:\">\u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m \u00e2m b\u1eb1ng Conditional formatting trong Excel:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_gia_tri_da_co_thanh_ty_le_phan_tram\"><\/span><strong>\u0110\u1ecbnh d\u1ea1ng gi\u00e1 tr\u1ecb \u0111\u00e3 c\u00f3 th\u00e0nh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi b\u1ea1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng <strong>Percentage<\/strong> cho c\u00e1c \u00f4 \u0111\u00e3 ch\u1ee9a s\u1ed1, Excel nh\u00e2n nh\u1eefng s\u1ed1 n\u00e0y v\u1edbi 100 v\u00e0 th\u00eam d\u1ea5u hi\u1ec7u ph\u1ea7n tr\u0103m (%) \u1edf cu\u1ed1i. Tuy nhi\u00ean, c\u00e1ch n\u00e0y kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng \u0111\u00fang. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 20 trong \u00f4 A1 v\u00e0 b\u1ea1n \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 2000%, ch\u1ee9 kh\u00f4ng ph\u1ea3i 20% nh\u01b0 b\u1ea1n mong \u0111\u1ee3i.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch gi\u1ea3i quy\u1ebft:<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>T\u00ednh s\u1ed1 ph\u1ea7n tr\u0103m tr\u01b0\u1edbc khi \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m. V\u00ed d\u1ee5, n\u1ebfu s\u1ed1 ban \u0111\u1ea7u c\u1ee7a b\u1ea1n \u1edf c\u1ed9t A, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c \u00f4 B2 = A2 \/ 100 \u00a0v\u00e0 sau \u0111\u00f3 copy cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t B. Sau \u0111\u00f3 ch\u1ecdn c\u1ed9t B v\u00e0 nh\u1ea5p <strong>Percent Style<\/strong>. B\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 sau:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-52.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4620 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-52.bmp\" width=\"456\" height=\"386\" title=\"new-bitmap-image-2-52\"><\/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-323.gif\" title=\"vba101_92019-nho-323\"><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-709.gif\" title=\"ex101_92019-nho-709\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Cu\u1ed1i c\u00f9ng, b\u1ea1n sao ch\u00e9p c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a c\u1ed9t B cho c\u1ed9t A v\u00e0 x\u00f3a ch\u00fang n\u1ebfu b\u1ea1n kh\u00f4ng c\u1ea7n n\u1eefa.<\/p>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n d\u00f9ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m cho v\u00e0i s\u1ed1, b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 s\u1ed1 d\u01b0\u1edbi d\u1ea1ng th\u1eadp ph\u00e2n tr\u1ef1c ti\u1ebfp v\u00e0o \u00f4. V\u00ed d\u1ee5, \u0111\u1ec3 c\u00f3 28% trong \u00f4 A2, g\u00f5 0,28 v\u00e0 d\u00f9ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dung_dinh_dang_phan_tram_cho_o_trong\"><\/span><strong>D\u00f9ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m cho \u00f4 tr\u1ed1ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi b\u1ea1n nh\u1eadp s\u1ed1 v\u00e0o \u00f4 tr\u1ed1ng \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m th\u00ec:<\/p>\n<ul style=\"text-align: justify\">\n<li>B\u1ea5t k\u1ef3 s\u1ed1 n\u00e0o b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 1 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i sang ph\u1ea7n tr\u0103m theo m\u1eb7c \u0111\u1ecbnh. V\u00ed d\u1ee5, 2 \u0111\u01b0\u1ee3c bi\u1ebfn th\u00e0nh 2%, 20 th\u00e0nh 20%, 2.1 th\u00e0nh 2,1%.<\/li>\n<li>Nh\u1eefng s\u1ed1 nh\u1ecf h\u01a1n 1 m\u00e0 kh\u00f4ng ghi \u201c0\u201d ph\u00eda tr\u01b0\u1edbc d\u1ea5u th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c nh\u00e2n v\u1edbi 100. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n g\u00f5 .2 v\u00e0o \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m, b\u1ea1n s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 20%. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n nh\u1eadp 0.2 trong \u00f4 t\u01b0\u01a1ng t\u1ef1, 0,2% s\u1ebd xu\u1ea5t hi\u1ec7n.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-53.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4621 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-53.bmp\" width=\"276\" height=\"212\" title=\"new-bitmap-image-2-53\"><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Hien_thi_so_phan_tram_theo_y_muon\"><\/span><strong>Hi\u1ec3n th\u1ecb s\u1ed1 ph\u1ea7n tr\u0103m theo \u00fd mu\u1ed1n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n g\u00f5 20% (v\u1edbi k\u00ed hi\u1ec7u ph\u1ea7n tr\u0103m) tr\u1ef1c ti\u1ebfp v\u00e0o m\u1ed9t \u00f4, Excel s\u1ebd hi\u1ec3u r\u1eb1ng b\u1ea1n \u0111ang nh\u1eadp v\u00e0o s\u1ed1 ph\u1ea7n tr\u0103m v\u00e0 t\u1ef1 \u0111\u1ed9ng \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p style=\"text-align: justify\"><em>L\u01b0u \u00fd quan tr\u1ecdng!<\/em><\/p>\n<p style=\"text-align: justify\">Khi \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m trong Excel, h\u00e3y nh\u1edb r\u1eb1ng \u0111\u00f3 l\u00e0 m\u1ed9t c\u00e1ch bi\u1ec3u \u0111\u1ea1t c\u1ee7a gi\u00e1 tr\u1ecb th\u1ef1c \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong \u00f4. C\u00e1c gi\u00e1 tr\u1ecb c\u01a1 b\u1ea3n lu\u00f4n \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef d\u01b0\u1edbi d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n.\u00a0N\u00f3i c\u00e1ch kh\u00e1c, 20% \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef nh\u01b0 0.2, 2% \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef nh\u01b0 0.02, 0.2% l\u00e0 0,002, vv\u2026 Khi th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh, Excel lu\u00f4n th\u1ef1c hi\u1ec7n d\u1ef1a v\u00e0o gi\u00e1 tr\u1ecb th\u1eadp ph\u00e2n. H\u00e3y nh\u1edb \u0111i\u1ec1u n\u00e0y khi tham chi\u1ebfu c\u00e1c \u00f4 trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb th\u1ef1c \u0111\u1eb1ng sau \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m, k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4, b\u1ea5m <strong><em>Format Cells<\/em><\/strong> (ho\u1eb7c \u00a0Ctrl + 1) v\u00e0 nh\u00ecn v\u00e0o h\u1ed9p <strong>Sample<\/strong> c\u1ee7a ph\u00e2n h\u1ec7 <strong>General <\/strong>trong tab<strong> Number.<\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-54.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4622 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-54.bmp\" width=\"541\" height=\"463\" title=\"new-bitmap-image-2-54\"><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Meo_de_hien_thi_phan_tram_trong_Excel\"><\/span><strong>M\u1eb9o \u0111\u1ec3 hi\u1ec3n th\u1ecb ph\u1ea7n tr\u0103m trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Hien_thi_phan_so_thap_phan\"><\/span><strong>Hi\u1ec3n th\u1ecb ph\u1ea7n s\u1ed1 th\u1eadp ph\u00e2n:\u00a0<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m cho c\u00e1c con s\u1ed1, Excel 2010 v\u00e0 2013 hi\u1ec3n th\u1ecb d\u1ea1ng l\u00e0m tr\u00f2n kh\u00f4ng c\u00f3 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y m\u1ed9t s\u1ed1 nh\u1ea7m l\u1eabn. V\u00ed d\u1ee5, \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m v\u00e0o m\u1ed9t \u00f4 tr\u1ed1ng v\u00e0 g\u00f5 0.2. B\u1ea1n th\u1ea5y g\u00ec? Trong Excel 2013, s\u1ed1 hi\u1ec3n th\u1ecb l\u00e0 0% m\u1eb7c d\u00f9 ta bi\u1ebft ch\u1eafc ch\u1eafn l\u00e0 0,2%.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 xem ph\u1ea7n tr\u0103m th\u1ef1c t\u1ebf thay v\u00ec b\u1ecb l\u00e0m tr\u00f2n b\u1ea1n ch\u1ec9 c\u1ea7n t\u0103ng s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, m\u1edf <strong>Format Cells<\/strong> ho\u1eb7c nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <strong>Ctrl + 1<\/strong> ho\u1eb7c k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o c\u00e1c \u00f4 v\u00e0 ch\u1ecdn <em>Format Cell<\/em>s \u2026. H\u00e3y ch\u1ecdn lo\u1ea1i \u0111\u1ecbnh d\u1ea1ng <strong>Percentage<\/strong> v\u00e0 thi\u1ebft l\u1eadp s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n mu\u1ed1n hi\u1ec3n th\u1ecb t\u1ea1i <strong><em>Decimal places<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-55.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4623 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-55.bmp\" width=\"541\" height=\"431\" title=\"new-bitmap-image-2-55\"><\/a><\/p>\n<p style=\"text-align: justify\">Khi ho\u00e0n t\u1ea5t, nh\u1ea5n n\u00fat OK \u0111\u1ec3 l\u01b0u c\u00e1c thi\u1ebft l\u1eadp c\u1ee7a b\u1ea1n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thiet_lap_dinh_dang_cho_so_phan_tram_am\"><\/span><strong>Thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng cho s\u1ed1 ph\u1ea7n tr\u0103m \u00e2m:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m \u00e2m theo m\u1ed9t c\u00e1ch kh\u00e1c, hi\u1ec3n th\u1ecb m\u00e0u \u0111\u1ecf, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh. M\u1edf h\u1ed9p tho\u1ea1i <strong>Format Cells<\/strong> m\u1ed9t l\u1ea7n n\u1eefa, t\u1ea1i tab <em>Number&gt;Custom <\/em>v\u00e0 nh\u1eadp m\u1ed9t trong nh\u1eefng \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi \u0111\u00e2y trong h\u1ed9p <strong>Type:<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>00%;[Red] -0,00% \u2013 \u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m \u00e2m m\u00e0u \u0111\u1ecf v\u00e0 hi\u1ec3n th\u1ecb 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/li>\n<li>0%;[Red] -0% \u2013 \u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m \u00e2m m\u00e0u \u0111\u1ecf v\u00e0 kh\u00f4ng hi\u1ec3n th\u1ecb s\u1ed1 th\u1eadp ph\u00e2n.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-56.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4624 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-56.bmp\" width=\"541\" height=\"470\" title=\"new-bitmap-image-2-56\"><\/a><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y trong <a href=\"http:\/\/office.microsoft.com\/en-us\/excel-help\/display-numbers-as-percentages-HP010342435.aspx#BM3\">Display numbers as percentages<\/a> c\u1ee7a Microsoft.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_phan_tram_am_bang_Conditional_formatting_trong_Excel\"><\/span><strong>\u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m \u00e2m b\u1eb1ng <\/strong><strong>Conditional formatting<\/strong><strong> trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">So v\u1edbi c\u00e1c ph\u01b0\u01a1ng ph\u00e1p tr\u01b0\u1edbc \u0111\u00f3, <strong>Conditional formatting<\/strong> \u0111a n\u0103ng h\u01a1n v\u00e0 cho ph\u00e9p b\u1ea1n hi\u1ec3n th\u1ecb nhi\u1ec1u s\u1ed1 ph\u1ea7n tr\u0103m \u00e2m, v\u00ed d\u1ee5 ph\u1ea7n tr\u0103m gi\u1ea3m.<\/p>\n<p style=\"text-align: center\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho ph\u1ea7n tr\u0103m \u00e2m l\u00e0 ch\u1ecdn <strong>Conditional formatting<\/strong> <strong>&gt;Highlight cells rules&gt;Less than<\/strong> v\u00e0 g\u00f5 0 trong \u00f4 <strong>\u201cFormat cells that are LESS THAN\u201d<\/strong>:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-57.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4625 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-57.bmp\" width=\"600\" height=\"219\" title=\"new-bitmap-image-2-57\"><\/a><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng t\u1eeb danh s\u00e1ch \u1edf b\u00ean ph\u1ea3i, ho\u1eb7c b\u1ea5m <strong>Custom Format\u2026<\/strong>\u1edf cu\u1ed1i danh s\u00e1ch \u0111\u1ec3 thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng ri\u00eang.<\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel.Online.<\/em><\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-du-lieu-su-dung-custom-format.html\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u s\u1eed d\u1ee5ng Custom Format<\/a><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-2-cach-tu-dong-dinh-dang-du-lieu-theo-icon-trong-excel.html\">H\u01b0\u1edbng d\u1eabn 2 c\u00e1ch t\u1ef1 \u0111\u1ed9ng \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u theo icon trong Excel<\/a><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-dinh-dang-va-ap-dung-cell-styles-mos-excel.html\">C\u00e1ch thi\u1ebft l\u1eadp, \u0111\u1ecbnh d\u1ea1ng v\u00e0 \u00e1p d\u1ee5ng Cell Styles trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>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\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\/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-323.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7886,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7885","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\/7885","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=7885"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7885\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7886"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}