Application of Excel data validation

After the exam, the teacher might want to highlight the Excel form in the red circle, and the company may also want to highlight the special data in the statistics. Such requirements can be easily accomplished with Excel's data availability. Let me give an example of how to achieve this requirement with the result sheet. (Note: This example requires that the language score above 120 points in the red Circle highlighted.) )

Screen operation steps:

The first step: open the results table → Choose the language results → Click the Data button on the menu bar → Select effectivity.

Step two: In the Data Validation dialog box, select "Integer" in the "Allow" → in the "Data" box, select "between" → minimum input 0→ maximum input 120→ OK.

Step three: Click the Tools button on the menu bar → select Formula auditing → Select Show the formula Auditing toolbar.

Fourth step: Click the "Circle Invalid Data" button.

So the Chinese score in 120 points above is circled in a red circle, played a prominent role.

But these loops can only be displayed on the computer and cannot be printed. Some teachers want to print it out, the author after exploring, to find a feasible way, the following introduction to this method.

Print operation steps:

The first step: Select the table → hold down the SHIFT key and click the Edit button on the menu bar → select Copy picture → OK.

Step Two: Click the "Edit" button on the menu bar → choose to paste the picture → delete the original datasheet → Adjust the location of the copied datasheet.

Note: You should always hold down the SHIFT key during the first and second steps, otherwise the operation will not succeed.