How to do the EXCEL lottery?

1. Assign a lottery number to everyone with the random function rand. Enter the formula in cell A 1:

=int(rand()* 1000)

Then drop down to fill.

2. Then select column A, set the conditional format, and use the formula to set the first three (or custom) to red:

=rank(a 1，a:a)& lt； four

(<4 means 3 before the exam. If you want 5 before the exam, change it to.

3. Press F9 every time to refresh the results.