Very nice, had to come back to watch this vid after 2 years!..Great Job lady!

This video is spot on, was able to create this for a euro millions checker. Very easy to follow, thanks!

WOW! Excellent! This is exactly what I was looking for! Thank you so much for this Tutorial. I Have also subscribed to your channel :-)

@Chan V you might need to use a semi-colon in your formula, instead of a comma

B-E-A-Utiful ! This video was made in 2010 , and it is still very useful and important today ! Thanks for this video ! 🧐🇬🇧🤔🤓🤝👍🏻❤️💪🏻

Thank you very much for posting this video. I was wondering how to do this.

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.

Love this video but would like to see if there a way you can change all the selected numbers if you were to change the ones in the drawn number cell?

Hi, Contextures. Can Conditional Formatting identify particular hours? I have a schedule of hours when classes are given. Can condition formatting be used to highlight the current hour? Thanks!

Hi Contextures. Thanks for these tutorials. I am using conditional formatting as you have in the video. On some sheets in the same workbook, it works perfectly. In other sheets, it does not highlight the data I want to check. In these sheets, if the first value in the reference cell (your number 3) is the same as the active cell in the data (your number 2) then all the cells are highlighted. Could you please give an explanation for this and a workaround? Take care.

thank you so much! u made my work easier

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.

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

What if you have to keep adding drawn numbers until their numbers are completely highlighted how would this work

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 !!

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

it doesn't work for excel 2016, does anyone know the solution please

Thanks

Has to be 3games?

instead to check number by number, how is possible to match by the whole row.

Can you help us on mega Millions or powerball on the next couple drawing in oct 2019 appreciate any help

how you do that in excel 2003

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

is this downloadable?

Why is not clear video ?

Merci pour votre vidéo je souhaiterais réaliser cette mise en forme. Je n’y arrivais pas même avec chatgpt !

Cool Thanks

I love you

Cool Thanks