Highlight Winning Lottery Numbers With Excel Conditional Formatting

Use conditional formatting in Excel to highlight the winning numbers in a list of lottery tickets.
The Excel COUNTIF function checks each number against the week’s winning numbers. If the number is in the list of drawn numbers, the cell is coloured.