How to automatically highlight the cells of pure Chinese characters in Excel

Please see the following action demo.

① start Excel2007, open the data table, select E Column, click the menu bar-start-conditional formatting-create a new rule.

② pops up the new Rule dialog box, the rule type selects the last one, uses the formula to determine the cell to format, enters the red-labeled formula below, and clicks the Format button.

③ sets the display format for cells, where we can match numbers, fonts, borders, and fill four options.

④ cell formatting is complete, let's take a look at the results. A closer look, e column is clearly Chinese characters, how did not highlight it? We clicked on one of the cells, and in the formula bar we saw numbers, not pure Chinese characters, but we automatically converted to Chinese when we entered numbers.

⑤ we enter the pure Chinese character in one of the cells, and after the carriage return is pressed, the cell becomes the form we set before, proving that the formula is valid.

Formula description

Calculates the number of characters in the E1 cell with Len, the result returned is 4, multiplied by 2, the result is 8, the byte number of the E1 cell character is computed with the LenB function, and the result returned is 8. So when you enter Chinese characters in the E column, the final result of the two formulas is equal. In addition, Len (E1) >0 means that E1 cells cannot be empty, and because the and function is used, cell formatting is automatically set when both conditions are met.