Highlight Lottery Numbers (TOTO) using Microsoft Excel

Let me show you an example how to highlight the ticket numbers that have been drawn in a lottery. Let said you have 5 ticket numbers that are in cells B4:G8 and the drawn numbers are entered in cells B2:G2.

1. Select cells B4:G8.
   
2. Choose [Format] > [Conditional Formatting].
   
3. From the first dropdown list, choose Formula Is.
   
4. For the formula, use the CountIf function: =COUNTIF($B$2:$G$6,B4)
   
5. Click the [Format] button.
   
6. Select formatting options (green pattern, in this example), then click [OK] button.
   
7. Finally, click [OK] button.

Wish you have a lucky day!