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.

16 Responses to "Highlight Winning Lottery Numbers With Excel Conditional Formatting"

jeyner lopez says:
October 11, 2011 at 8:22 pm
from your example how can I get the list of the position number. in your example 15 is in the first ticket and the second but if I want to know the position of each number before and got the list, how is possible to do that
Reply
jeyner lopez says:
October 11, 2011 at 8:39 pm
how you do that in excel 2003
Reply
jeyner lopez says:
December 16, 2011 at 5:43 pm
instead to check number by number, how is possible to match by the whole row.
Reply
bluesbender69 says:
July 14, 2012 at 3:30 pm
Thank you very much for posting this video. I was wondering how to do this.
Reply
Mike Killpartrick says:
August 20, 2013 at 11:26 am
Cool Thanks
Reply
Mike Killpartrick says:
August 20, 2013 at 11:26 am
Cool Thanks
Reply
V.T.A. Wolf says:
August 22, 2013 at 10:29 am
Hey, this was a great example..I’ve been trying to something like this for the longest time..tried it and works great..thank you..but is there a way that you can add how many numbers match to the right and have it also highlight numbers matched for each line..
Reply
Chan V says:
June 2, 2014 at 2:17 pm
Hello all I am trying to do this but my PC Excel 2007 it is not working? untill range selecting is well after “COMMA” it is not working anyone has idea? please help me
Reply
Contextures Inc. says:
June 4, 2014 at 12:48 pm
@Chan V you might need to use a semi-colon in your formula, instead of a comma
Reply
eurossocial says:
October 18, 2014 at 10:23 am
WOW! Excellent! This is exactly what I was looking for! Thank you so much for this Tutorial. I Have also subscribed to your channel 🙂
Reply
Steven Worwood says:
February 24, 2015 at 12:50 pm
This video is spot on, was able to create this for a euro millions checker.
Very easy to follow, thanks!
Reply
Doyeon Lee says:
January 13, 2016 at 1:38 am
Has to be 3games?
Reply
Geo T says:
April 17, 2016 at 6:35 am
Doing this comparison with a long list of drawn numbers vs. just one row at a time is my goal. I’ve seen programs that do it but there’s got to be a free way.
Reply
Desmond Lee says:
August 1, 2016 at 12:04 pm
This is a fantastic video. Basically creating your own search engine.
I have a question about the second method. How do I get excel to display the tickets with the most matched numbers first?
(and then the ones with the least matched numbers displays last.)
Thank You in advance !!
Reply
Danny Belanger says:
September 21, 2016 at 10:44 pm
What if you have to keep adding drawn numbers until their numbers are completely highlighted how would this work
Reply
Mark Norville says:
March 11, 2017 at 10:16 pm
Just to say thanks, I have got back into Excel the past few days, as I wanted a lottery checker. I have done the opposite of your demo, I have one sheet for my tickets and one sheet for the drawing. I have a formula to check for the maximum numbers matched on one line, but I have used this example so that when I enter the drawn numbers if I have that number in my tickets, the drawn section turns blue. It is just an added feature, as you could have all balls, but not in one line. I tried it out tonight, but sadly only one turned blue, still always next drawing.
Reply

More Cool Stuff:

Leave a Reply Cancel reply