formula to highlight the my selected numbers in red

[di_800]

Hi all I've been trying to figure this out but no go. I'm trying to basically like a bingo with my kids. I type in a row of six numbers and i get the program to highlite the numbers in red that i picked for example

picked numbers 1-2-3-4-5-6-7

John 3-4-10-11-12-13-14-----2 numbers highlited 3 and 4

he has basically 3 and 4 highlited in red a have that part figured out but i want it to count that he has two numbers highlited or two cells is there a way of doing this. I hope i made sense. Thanks.

[Ron Coderre]

With
A1:A7 contains this list: 1,2,3,4,5,6,7
and
C1:C7 contains this list: 3,4,10,11,12,13,14

This formula counts the items in C1:C7 that are
in A1:A7:

Please Login or Register  to view this content.

In the above example, D1 returns: 2

Is that something you can work with?

[di_800]

Hi ron thanks for the reply. Very new at this just trying new things. Do I have to add a new conditional format or where do i put that formula . Here is an example of my formula for mine

formula is =countif($C$3:$I$12,C14) when i input numbers it highlites them all from c14 and on

$C$3:$I$12 is where i pick my numbers and C14 is where i have 5 names basically from c14 to i18 for example. Thanks for your help. Does this make any sense.