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.