How does excel highlight the birth date of a certain year in the ID card? For example, 1986 is highlighted in red.

The setting method is as follows:

1. If column A is the ID number, click to select cell A 1.

2. Click Conditional Format under the Start menu, and click New Rule in the drop-down menu.

3. Click "Determine the cells to be formatted by formula", enter = ((mid (A 1, 7,4) = "1986"), and click "Format".

4. Click Color in the expanded format, use red, and then click OK.

5. Then click OK in the new format rule window.

6. Click to select cell A 1, click "Format Brush" under the start menu, and then brush "Column A".

Seven, the effect is as follows, 1986 birth ID number is highlighted in red.