Highlight numbers that have been drawn from bingo/lotto

[cjaustin1792]

I am wanting to enter the weekly lottery numbers in the Draw Date / Number cells. Then I want the Already Drawn table to update by highlighting what has been drawn and then highlight everyone elses in the list to the left.

I would massively appreciate any help. The size of this list is going to be massive so want to get it right before I start inputting everyone.#

Thank you

 

[cjaustin1792]

Staff of Life Lotto.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2		Staff of Life Bingo
3
4		Name	Number									Already Drawn
5		Aden Crew	1	2	11	20	29	34	42	59		1	2	3	4	5	6	7	8	9	10
6		Barry Bowes	3	5	9	12	17	29	45	49		11	12	13	14	15	16	17	18	19	20
7		Beth Reddy	8	11	12	17	21	26	29	53		21	22	23	24	25	26	27	28	29	30
8		Brian Hart	4	8	15	21	23	25	38	55		32	32	32	32	32	32	32	32	32	32
9		Carl Betts	4	6	7	12	16	19	30	59		41	42	43	44	45	46	47	48	49	50
10		Charlie Smith	8	10	11	17	21	23	32	41		51	52	53	54	55	56	57	58	59
11		Chris Moore	1	10	12	14	35	46	50	55
12		Claire Sanderson	1	2	7	14	19	22	29	31		Draw Date				Number
13		Dave Cee	3	8	17	19	21	22	27	44		02/02/2022				6	22	29	48	50	59
14		Des	2	8	13	16	17	24	25	35
15		Don Brown	3	9	14	17	29	35	47	59
16		Ezza	11	14	18	20	24	33	44	45
17		Gordon	8	9	12	15	18	28	36	56
18		Ian Morrison	3	5	11	16	21	22	33	47
19		Jan Roidl	6	11	14	19	21	22	33	49
20		John Lee	8	10	15	22	30	36	45	59
21		John Morgan	5	20	22	29	30	44	47	58
22		Julie	5	8	18	28	38	43	48	58
23		Keith Shooter	1	7	19	24	30	38	40	44
24		Kelly Robinson	1	3	9	13	19	28	30	54
25		Kenny C	1	3	5	9	12	17	18	47
26		Kerry Crompton	1	4	8	12	17	19	43	44
27		Kirsty Stuart	2	6	12	14	22	23	28	35
28		Lisa Johnson	9	10	13	14	22	24	31	49
29		Liz Jackson	1	6	11	21	24	27	33	55
30		Marcus Boyce	4	5	13	20	22	28	31	41
31		Martin & Shell	3	6	9	10	19	21	23	40
32		Micheal Doran	4	7	16	17	20	28	29	50
33		Micheal Hodgson	4	6	9	10	13	14	20	40
34		Neil Smith	11	17	28	32	37	43	47	59
35		Nidge	1	8	11	25	38	40	58	59
36		Paul Rodgers	5	7	14	22	28	32	49	51
37		Paul Roidl	4	7	11	13	20	32	37	57
38		Paul Willard	7	9	11	18	20	22	29	33
39		Pete Singh	1	9	12	13	18	22	33	44
40		Rob N Val	16	23	26	30	32	37	45	46
41		Robbie	6	7	11	13	14	25	26	44
42		Russ Williams	9	16	17	23	34	44	46	51
43		Steve Marie	2	6	19	32	35	38	43	51
44		Steve Willard	2	7	9	11	22	29	42	44
45		Sue Riley	2	9	14	24	28	33	44	48
46		Tez Kitchen	6	14	21	24	28	32	42	50
47		Wayne Rodgers	2	12	20	22	24	29	21	44
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L5:U10	Cell Value	contains "P13:U13"	text	NO

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2		Staff of Life Bingo
3
4		Name	Number									Already Drawn
5		Aden Crew	1	2	11	20	29	34	42	59		1	2	3	4	5	6	7	8	9	10
6		Barry Bowes	3	5	9	12	17	29	45	49		11	12	13	14	15	16	17	18	19	20
7		Beth Reddy	8	11	12	17	21	26	29	53		21	22	23	24	25	26	27	28	29	30
8		Brian Hart	4	8	15	21	23	25	38	55		32	32	32	32	32	32	32	32	32	32
9		Carl Betts	4	6	7	12	16	19	30	59		41	42	43	44	45	46	47	48	49	50
10		Charlie Smith	8	10	11	17	21	23	32	41		51	52	53	54	55	56	57	58	59
11		Chris Moore	1	10	12	14	35	46	50	55
12		Claire Sanderson	1	2	7	14	19	22	29	31		Draw Date				Number
13		Dave Cee	3	8	17	19	21	22	27	44		02/02/2022				6	22	29	48	50	59
14		Des	2	8	13	16	17	24	25	35
15		Don Brown	3	9	14	17	29	35	47	59
16		Ezza	11	14	18	20	24	33	44	45
17		Gordon	8	9	12	15	18	28	36	56
18		Ian Morrison	3	5	11	16	21	22	33	47
19		Jan Roidl	6	11	14	19	21	22	33	49
20		John Lee	8	10	15	22	30	36	45	59
21		John Morgan	5	20	22	29	30	44	47	58
22		Julie	5	8	18	28	38	43	48	58
23		Keith Shooter	1	7	19	24	30	38	40	44
24		Kelly Robinson	1	3	9	13	19	28	30	54
25		Kenny C	1	3	5	9	12	17	18	47
26		Kerry Crompton	1	4	8	12	17	19	43	44
27		Kirsty Stuart	2	6	12	14	22	23	28	35
28		Lisa Johnson	9	10	13	14	22	24	31	49
29		Liz Jackson	1	6	11	21	24	27	33	55
30		Marcus Boyce	4	5	13	20	22	28	31	41
31		Martin & Shell	3	6	9	10	19	21	23	40
32		Micheal Doran	4	7	16	17	20	28	29	50
33		Micheal Hodgson	4	6	9	10	13	14	20	40
34		Neil Smith	11	17	28	32	37	43	47	59
35		Nidge	1	8	11	25	38	40	58	59
36		Paul Rodgers	5	7	14	22	28	32	49	51
37		Paul Roidl	4	7	11	13	20	32	37	57
38		Paul Willard	7	9	11	18	20	22	29	33
39		Pete Singh	1	9	12	13	18	22	33	44
40		Rob N Val	16	23	26	30	32	37	45	46
41		Robbie	6	7	11	13	14	25	26	44
42		Russ Williams	9	16	17	23	34	44	46	51
43		Steve Marie	2	6	19	32	35	38	43	51
44		Steve Willard	2	7	9	11	22	29	42	44
45		Sue Riley	2	9	14	24	28	33	44	48
46		Tez Kitchen	6	14	21	24	28	32	42	50
47		Wayne Rodgers	2	12	20	22	24	29	21	44
Lists

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C5:J47	Expression	=COUNTIFS($P$13:$U$13,C5)	text	NO
L5:U10	Expression	=COUNTIFS($P$13:$U$13,L5)	text	NO

 

[cjaustin1792]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2		Staff of Life Bingo
3
4		Name	Number									Already Drawn
5		Aden Crew	1	2	11	20	29	34	42	59		1	2	3	4	5	6	7	8	9	10
6		Barry Bowes	3	5	9	12	17	29	45	49		11	12	13	14	15	16	17	18	19	20
7		Beth Reddy	8	11	12	17	21	26	29	53		21	22	23	24	25	26	27	28	29	30
8		Brian Hart	4	8	15	21	23	25	38	55		32	32	32	32	32	32	32	32	32	32
9		Carl Betts	4	6	7	12	16	19	30	59		41	42	43	44	45	46	47	48	49	50
10		Charlie Smith	8	10	11	17	21	23	32	41		51	52	53	54	55	56	57	58	59
11		Chris Moore	1	10	12	14	35	46	50	55
12		Claire Sanderson	1	2	7	14	19	22	29	31		Draw Date				Number
13		Dave Cee	3	8	17	19	21	22	27	44		02/02/2022				6	22	29	48	50	59
14		Des	2	8	13	16	17	24	25	35
15		Don Brown	3	9	14	17	29	35	47	59
16		Ezza	11	14	18	20	24	33	44	45
17		Gordon	8	9	12	15	18	28	36	56
18		Ian Morrison	3	5	11	16	21	22	33	47
19		Jan Roidl	6	11	14	19	21	22	33	49
20		John Lee	8	10	15	22	30	36	45	59
21		John Morgan	5	20	22	29	30	44	47	58
22		Julie	5	8	18	28	38	43	48	58
23		Keith Shooter	1	7	19	24	30	38	40	44
24		Kelly Robinson	1	3	9	13	19	28	30	54
25		Kenny C	1	3	5	9	12	17	18	47
26		Kerry Crompton	1	4	8	12	17	19	43	44
27		Kirsty Stuart	2	6	12	14	22	23	28	35
28		Lisa Johnson	9	10	13	14	22	24	31	49
29		Liz Jackson	1	6	11	21	24	27	33	55
30		Marcus Boyce	4	5	13	20	22	28	31	41
31		Martin & Shell	3	6	9	10	19	21	23	40
32		Micheal Doran	4	7	16	17	20	28	29	50
33		Micheal Hodgson	4	6	9	10	13	14	20	40
34		Neil Smith	11	17	28	32	37	43	47	59
35		Nidge	1	8	11	25	38	40	58	59
36		Paul Rodgers	5	7	14	22	28	32	49	51
37		Paul Roidl	4	7	11	13	20	32	37	57
38		Paul Willard	7	9	11	18	20	22	29	33
39		Pete Singh	1	9	12	13	18	22	33	44
40		Rob N Val	16	23	26	30	32	37	45	46
41		Robbie	6	7	11	13	14	25	26	44
42		Russ Williams	9	16	17	23	34	44	46	51
43		Steve Marie	2	6	19	32	35	38	43	51
44		Steve Willard	2	7	9	11	22	29	42	44
45		Sue Riley	2	9	14	24	28	33	44	48
46		Tez Kitchen	6	14	21	24	28	32	42	50
47		Wayne Rodgers	2	12	20	22	24	29	21	44
Lists

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C5:J47	Expression	=COUNTIFS($P$13:$U$13,C5)	text	NO
L5:U10	Expression	=COUNTIFS($P$13:$U$13,L5)	text	NO

You genius. This may seem simple to you with the timeframe it took you but this has been baffling me for a while. Thank you very much. I appreciate it so much

 

[Fluff]

You're welcome & thanks for the feedback.