Highlight Winning Lottery Numbers With Excel Conditional Formatting

29
348
ef34cf7cc22d6e48b9446c5609cfc40e
ef34cf7cc22d6e48b9446c5609cfc40e

Highlight Winning Lottery Numbers
No, I’ve never won the lottery, but that’s probably because I don’t buy tickets! Your odds of winning improve (slightly) if you actually have a ticket for the draw.

However, there are many workplaces where someone has organized a weekly lottery pool, and they have a batch of ticket numbers to check.

Instead of checking those numbers manually (and missing one or two!), you can use Excel to check them for you. It won’t even ask for a percentage, if you are lucky enough to win a prize.

Set Up the Worksheet
In this example, the winning numbers have been entered at the top of a worksheet, in cells C3:H3.

Below that, all the tickets numbers have been entered, in cells C6:H8.

Highlight the Winning Numbers
After all the numbers are entered, you can use conditional formatting to highlight the ticket numbers that were selected in the weekly draw. We’ll use the COUNTIF function in the conditional formatting rule, just as it could be used on the worksheet.

  1.  Select cells C6:H8 – cell C6 is the active cell in the selection, so it will be used as a reference in the conditional formatting rule.
  2. On the Ribbon’s Home tab, click Conditional Formatting, then click New Rule
  3. Click “Use a Formula to Determine Which Cells to Format”
  4. For the formula, use the COUNTIF function:
    =COUNTIF($C$3:$H$3,C6)>=1
  5. Click the Format button.
  6. Select formatting options (green fill, in this example), click OK
  7. Click OK

The COUNTIF formula checks the cells with the weekly draw numbers (C3:H3), and counts how many times the value in cell C6 is in that range.

  • The reference to $C$3:$H3 is absolute, because all the cells should check that range for winning numbers.
  • The reference to C6 is relative, because it should adjust, for each cell in the ticket number range – C6:H8
    lotterywinners03

Download the Sample File
To see how the conditional formatting works, you can download the sample file from my website, on the Conditional Formatting Examples page.

Watch the Video
You can watch this short video, to see how the conditional formatting is set up.

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.

The Secret Technique that I been using to win Lottery Consistently!

***

The Secret Technique that I been using to win Lottery Consistently! Part 2

it is important

 

CHECK JACKPOT

YOUR LOTTERY!

Click to watch1

thelotter2

it is important

Spread

29 COMMENTS

  1. 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

  2. given 24 numbers, (97,101,139,41,37,31,29,89,23,19,8,13,131,19,73,97,19,139,79,67,61,17,113,127)taken 5 at a time, generate the unique combinations add up to 200. so, num combination to test 42504, optimal results 27 groups of 5 numbers : example (8-17-37-41-97)-(8-13-37-41-101)
    etc. this program is in java. How is possible to do this in EXCEL 2003 .

  3. 皆様にご相談があります…どなたかお金にお困りの方おりませんか?私は自分のお金の使い道に困っております。自分の諸事情なのですが…どなたか5,000,000円受け取って下さる方いらっしゃいませんか?どなたにでもお譲り致します。条件等は一切ございません。いきなりこんな所に書き込んでしまって失礼を承知の上ですが、どなたかに受け取って頂きたく思っております。
    受け取って頂けるという方は、youtube内の動画検索にて【 お金差し上げます 】で、検索してみて下さい。詳細はそこに記載しております。
    こちらから【http://bb99.info】も、見て頂く事ができます…いきなりこんなの信じられないかもしれませんが、
    お困りの方は早急にご連絡の方お待ちしております…

  4. Hi, have you tried “Reveal TravelDeal” (search on Google for it)? I have stumbled upon quite a few extremely affordable hotels and even flight tickets. This may allow you to save on your upcoming getaway also.

  5. Hello, have you tried out “Reveal Travel Deal” (do a Google search for it)? I have seen various amazingly affordable hotels as well as plane tickets. This might help you to save money on your future trip also.

  6. New Identity and Documents!
    We specialize in Paper Tripping, I.D. and closely guarded secrets of Complete Authentic Identity Change and everything that you need to disappear and to be reborn anywhere in the world.

    Email: FakeIDIDentityChange@yahoo.com
    Skype: FakeIDIdentityChange

  7. A Complete AUTHENTIC Identity Change and Documents!
    With our confidential resources, top of the line technology and complete IDs and Materials you now can be reborn anywhere in the world for whatever reason and never be found! Series Applicants Only! $290 Email: FakeIDIdentityChange@yahoo.com

  8. A Complete AUTHENTIC Identity Change and Documents!
    With our confidential resources, top of the line technology and complete IDs and Materials you now can be reborn anywhere in the world for whatever reason and never be found! Series Applicants Only! $800
    Email: FakeIDIdentityChange@yahoo.com

  9. We would like to introduce TravellingDocuments, company production of original documents since 2002.
    Buy passports, identity cards, driving licenses, birth certificates and visa stamps online with the safest and most discrepcion.
    You can ask your questions about the use of passports at airports and what you should do to maintain the highest anonymity.
    Is required within 3-7 days to complete any order

    Make your request by email to travellingdocuments@yahoo.com

  10. Hello I been to europe many times I got discount tickets check out europeantourvideos com on site mant cities I visited free movies clips check out my channel too films made in Budapest and Cannes

  11. help me! Have you thought about this “vermont lottery master” statistician (put in google)? Ive heard plenty oppinions unbelivable words about him and with my friend we thinking about crazy amounts of cash to get with his blueprint. should we use ^ Vermont lottery master amazing system.

  12. My local TA saved me thousands on a trip to hawaii. Orbitz couldn’t even get close to the price. We went apple because they have great discount rates. Don’t waste money on an expensive hotel, get the cheap one and spend your vacation time outside.

  13. So, to sum up. See a travel agent or if you want to, go online. Or, go see a travel agent. Glad this is only a minute long because it’s not helpful information.

LEAVE A REPLY

This site uses Akismet to reduce spam. Learn how your comment data is processed.