Lottery Numbers

[something68]

I would like to highlight the numbers I played if they are the same as numbers drawn, i.e., if any numbers in cells b3 to f3 are the same as drawn numbers in k3 to o3, I would like to highlight. I have tried several formulas but they either don't highlight or they highlight numbers that are anywhere on the sheet.

Here is where i used =countif(b3:f3,k33) but as you can see number 37 and 69 are highlighted but are not drawn on the dates I played.

 

[Fluff]

Hi & welcome to MrExcel.
Try

=COUNTIFS($K3:$P3,B3)

 

[something68]

I tried that and it worked! But, I would like to keep the "Ball" numbers separate from the other 5 numbers.

I actually tried =countifs($k3:$o3,b3) and it did keep some of the "ball" number separate, but not all. I highlighted columns b through f to put in the conditional formatting formula you gave me. I'm not very excel formula saavy so I want to make sure the formula goes in those columns or in columns k through o?

 

[something68]

Disregard. I deleted the rule, typed it back in several times and when that didn't work, I got out of the workbook...basically, I kept trying the formula and it finally worked for all tabs of that workbook.

Thank you!

 

[Fluff]

Glad it's sorted & thanks for letting us know.