1. First of all, we should open our Excel20 13 form and list the participants in this lucky draw.
(Click on the small picture to see the big picture)
2. Then enter it in the F2 cell.
= indirect ("d" & int (rand () *13+2))
(Click on the small picture to see the big picture)
3.
The meaning of the formula is: the int function returns a random integer of 2- 14, and concatenating it with d will return a random cell between D2: D 14. Finally, indirect will return the name in the random cell.
Enter the car and get a person's name: Sun Tianle.
(Click on the small picture to see the big picture)
4.
Select from A to D, and click the menu bar-Conditional Format-New Rule Option.
(Click on the small picture to see the big picture)
5.
Select the last rule type, which has been marked with a red line on the way. Use formulas to determine which cells to format. Enter the formula: =$D 1=$F$2, and then click the format button.
(Click on the small picture to see the big picture)
6.
A new format rule box pops up, as shown in the figure below. You can set the cell format, that is, the realistic way of winners in the list to distinguish them from others.
(Click on the small picture to see the big picture)
7.
Look at the final effect of our form after confirmation.
(Click on the small picture to see the big picture)
We are in www.ew8.cn.
Sun Tianle of Zhengzhou Easy Net Technology Co., Ltd. is our winner. Is it clear? Uh huh! Is this lottery system made of Excel20 13 table good? Oh, finally press F9 to refresh, and you are lucky again. Ok, blue 1000. Today, the system of making random lottery with Excel20 13 is a fair random lottery system and cannot be faked. If you need a controlled lottery ticket, I'll tell you when I have time.