Share via

Conditional Formatting excel lottery numbers sheet.

Anonymous
2018-09-18T17:49:58+00:00

Hello

How can i highlight (formula) in the chart below when one person acquires all six numbers on a spreadsheet?

22/09/18 Numbers Drawn 3 15 25 26 36 49
Ticket
John 2 15 26 27 36 48
Steve 1 12 13 15 24 34
Paul 3 5 20 26 49 40

Thanks, Paul

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-09-18T19:39:45+00:00

    This worked for me.

    Select cells B4:G4 (next to John), and use the conditional formula

    =AND($B4=$B$1,$C4=$C$1,$D4=$D$1,$E4=$E$1,$F4=$F$1,$G4=$G$1)

    Then use the "Format Painter"  to copy the conditional format to  columns B:G in subsequent rows.

    Hope this helps getting started.

    Was this answer helpful?

    0 comments