Conditional formatting help needed

[dfgkafdee]

I have a spreadsheet where I would like to highlight multiple cells based on another matching cell. Can someone please help me with the conditional formatting? This is a screenshot of what I am trying to accomplish. I would like to highlight the matching numbers in $A$23:$E$23 and $A$1:$E$20 as red as I enter a number in $A$23:$E$23. I would like to highlight the matching numbers in $A$24:$E$24 and $A$1:$E$20 as blue as I enter a number in $A$24:$E$24. I would like to highlight the matching numbers in grey $A$25:$E$25 and $A$1:$E$20 as red as I enter a number in $A$25:$E$25.

Cash 5.xlsx
	A	B	C	D	E	F
1	2	5	29	33	40	109
2	11	18	25	36	42	132
3	6	16	20	35	41	118
4	3	13	21	30	43	110
5	5	15	22	25	36	103
6	9	19	24	36	42	130
7	1	7	16	28	39	91
8	4	8	12	23	32	79
9	10	14	17	24	26	91
10	5	9	28	32	43	117
11	8	14	23	27	42	114
12	19	21	25	38	43	146
13	3	4	19	25	28	79
14	6	37	38	42	43	166
15	13	24	31	34	37	139
16	12	14	22	28	33	109
17	9	16	23	34	37	119
18	5	11	19	22	36	93
19	7	10	18	21	32	88
20	5	15	25	38	43	126
21
22
23						Hot
24						Cold
25						Overdue
My Picks

Cell Formulas
Range	Formula
F1:F20	F1	=SUM(A1:E1)

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

Fluff.xlsm
	A	B	C	D	E	F
1	2	5	29	33	40	109
2	11	18	25	36	42	132
3	6	16	20	35	41	118
4	3	13	21	30	43	110
5	5	15	22	25	36	103
6	9	19	24	36	42	130
7	1	7	16	28	39	91
8	4	8	12	23	32	79
9	10	14	17	24	26	91
10	5	9	28	32	43	117
11	8	14	23	27	42	114
12	19	21	25	38	43	146
13	3	4	19	25	28	79
14	6	37	38	42	43	166
15	13	24	31	34	37	139
16	12	14	22	28	33	109
17	9	16	23	34	37	119
18	5	11	19	22	36	93
19	7	10	18	21	32	88
20	5	15	25	38	43	126
21
22
23	2	12	15	23	43	Hot
24						Cold
25						Overdue
Data

Cell Formulas
Range	Formula
F1:F20	F1	=SUM(A1:E1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:F20	Expression	=COUNTIFS($A$23:$E$23,A1)	text	NO

And similar for the other two colours.