{"id":7172,"date":"2025-12-28T14:55:02","date_gmt":"2025-12-28T07:55:02","guid":{"rendered":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/?p=7172"},"modified":"2025-12-28T14:55:02","modified_gmt":"2025-12-28T07:55:02","slug":"cach-nhap-ten-san-pham-la-excel-tu-highlight","status":"publish","type":"post","link":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/cach-nhap-ten-san-pham-la-excel-tu-highlight\/","title":{"rendered":"C\u00c1CH NH\u1eacP T\u00caN S\u1ea2N PH\u1ea8M L\u00c0 EXCEL T\u1ef0 HIGHLIGHT"},"content":{"rendered":"

\"\"<\/p>\n

B\u01b0\u1edbc 1: C\u00e1c b\u1ea1n b\u00f4i ch\u1ecdn to\u00e0n b\u1ed9 c\u00e1c \u00f4 tr\u00e1i c\u00e2y v\u00e0 v\u00e0o th\u1ebb Home \u2013 Conditional Formatting.<\/b><\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 2: Ch\u1ecdn New Rule.<\/b><\/p>\n

\"\"<\/p>\n

\u1ede h\u1ed9p tho\u1ea1i\u00a0New Formatting Rule<\/b>\u00a0ch\u1ecdn\u00a0Use a formula to determine which cells to format.<\/b><\/div>\n
Nh\u1eadp\u00a0=$E2=0<\/b>\u00a0v\u00e0o\u00a0Format values where this formula is true.<\/b><\/div>\n
Sau \u0111\u00f3 ch\u1ecdn Format.<\/b><\/div>\n
\"\"<\/div>\n

B\u01b0\u1edbc 3: Ch\u1ecdn Fill\u00a0<\/b>v\u00e0 ch\u1ecdn m\u00e0u b\u1ea1n mu\u1ed1n r\u1ed3i nh\u1ea5n\u00a0OK.<\/b><\/p>\n

\"\"<\/p>\n

OK.<\/strong><\/p>\n

\"\"<\/p>\n

L\u00fac n\u00e0y b\u1ea1n s\u1ebd th\u1ea5y s\u1ea3n ph\u1ea9m Cam<\/strong> \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u \u0111\u1ecf<\/strong> v\u00ec n\u00f3 \u0111\u00e3 kh\u00f4ng c\u00f2n t\u1ed3n kho.<\/p>\n

\"\"<\/p>\n

Th\u1eed xu\u1ea5t h\u1ebft Qu\u00fdt \u0111i xem k\u1ebft qu\u1ea3 nh\u00e9, Qu\u00fdt \u0111\u00e3 \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u<\/strong> khi ch\u00fang ta xu\u1ea5t h\u1ebft h\u00e0ng.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 4: Thay v\u00ec \u0111i\u1ec1u ki\u1ec7n l\u00e0 h\u1ebft t\u1ed3n kho, b\u1ea1n c\u00f3 th\u1ec3 gi\u1edbi h\u1ea1n m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3 nh\u01b0 ch\u00fang ta s\u1ebd t\u00f4 nh\u1eefng s\u1ea3n ph\u1ea9m t\u1ed3n nh\u1ecf h\u01a1n 5 ch\u1eb3ng h\u1ea1n, \u0111\u1ec3 ch\u00fang ta ch\u00fa \u00fd nh\u1eadp th\u00eam m\u1eb7t h\u00e0ng \u0111\u00f3 tr\u00e1nh thi\u1ebfu h\u00e0ng.<\/p>\n

\"\"<\/p>\n

K\u1ebft qu\u1ea3.<\/strong><\/span><\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

B\u01b0\u1edbc 1: C\u00e1c b\u1ea1n b\u00f4i ch\u1ecdn to\u00e0n b\u1ed9 c\u00e1c \u00f4 tr\u00e1i c\u00e2y v\u00e0 v\u00e0o th\u1ebb Home \u2013 Conditional Formatting. B\u01b0\u1edbc<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/7172"}],"collection":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/comments?post=7172"}],"version-history":[{"count":3,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/7172\/revisions"}],"predecessor-version":[{"id":7185,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/7172\/revisions\/7185"}],"wp:attachment":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/media?parent=7172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/categories?post=7172"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/tags?post=7172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}