Highlight Winning Lottery Numbers - Excel Conditional Formatting

[@excelisfun]

Thanks for the video!

[@Garyx420]

refresher for a project.

[@tonykomery7991]

thank you for the info

[@contextures]

You're welcome, Tony, and thanks for your comment!

[@safiqulislam4670]

Nice video with excellent voice

[@contextures]

Thank you, Safiqul!

[@MrDavidcaldwell]

Brilliant very simple and practical:) how excel should be:)

[@mikegalvin1695]

Thank you for your help!!

[@contextures]

You're welcome, Mike! Thanks for your comment.

[@vcky8093]

THANKS FOR THIS VIDEO :)

[@contextures]

You're welcome! Thanks for watching it, V!CkY

[@aaart_for_nana_]

How do I highlight the winning ticket under different condition, like one colour for those that got 5 numbers and a different one for those that only got 4

[@contextures]

You'll have to set up a separate rule for each colour. In the rule's formula, check for a specific count, instead of ">1". For example: =COUNTIF($C$3:$H$3,C6)=4

[@goodnight755]

Thank you :*

[@geeyahnino3211]

How do i get it to highlight the number of a pick 4 if it's not in the same order, aka boxed? I can only get it to highligh if it's a straight hit.

[@michaelhofmann6552]

Thank you for this but how can I do this in reverse where it checks the numbers but highlights the other set if a match is found

[@contextures]

You're welcome, and to highlight the numbers that weren't found, change the conditional formatting to this:
=COUNTIF($C$3:$H$3,C6)=0

[@michaelhofmann6552]

@@contextures thanks again

[@emylo9099]

And how i can do if i have more drawns ? For exmple for last 4 weeks

[@justinejaybernardino8340]

Google sheet version?

[@apoplexis]

FYI: I've only managed to use the formula with a semicolon within my table:
=COUNTIF($B$1:$G$1;B3)>=1
otherwise, i got the error, that the formula is wrong.
Using office 2013 with the latest service packs and updates.

[@maxxiimus]

Thanks for this tip!