Highlight Winning Lottery Numbers - Excel Conditional Formatting 

refresher for a project.

Nice video with excellent voice

Thanks for the video!

thank you for the info

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

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.

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

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

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

Google sheet version?

Thank you for your help!!

THANKS FOR THIS VIDEO :)

Thank you :*

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.