For example, as shown in the figure, the circle publishes the score of failing mathematics (that is, the score is lower than 60 points);

Before publishing invalid data, we need to set data validity: select B2 to B 1 1 region-data (in the functional area)-data validity-data validity;

In the pop-up data validity command window, select Settings.

Allow: Select "Integer"

Data: Select "greater than or equal to"

Minimum value: enter 60 and click OK;

After data validity is set, invalid data will be released: data-data validity-invalid data will be released;

After clicking "Circle invalid data", we will see that all those whose math scores have not reached 60 have been circled, as shown in the following figure:

How to get rid of the strange circle of "releasing invalid data": data-data validity-clearing the strange circle of invalid data identification?