Find if specific values are on the same line

[Cypress]

Hello everyone.
I am new to Mr.excel. I hope I will make myself clear of what I need to do.
I have a sheet of numbers and I need to find if 4 specific numbers are on the same line.
For example if “1” and “23” and “54” and “132” are on the same line I need to get informed somehow. f.e. make the whole line red or something like that.
Obviously, I need to check the whole sheet for any occurrences.
Thank you in advance.

 

[navic]

are on the same line I need to get informed somehow. f.e. make the whole line red or something like that.

You can try, select range and put formula in Conditional Formatting

=COUNTIF($A2:$H2,$M$2)+COUNTIF($A2:$H2,$N$2)+COUNTIF($A2:$H2,$O$2)+COUNTIF($A2:$H2,$P$2)=4

or

=SUMPRODUCT((($A2:$H2=$M$2)+($A2:$H2=$N$2)+($A2:$H2=$O$2)+($A2:$H2=$P$2)))=4

Row/Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Num1	Num2	Num3	Num4	Num5	Num6	Num7	Num8		Countif	Sumproduct		Criteria1	Criteria2	Criteria3	Criteria4
2	1	2	23	3	5	54	124	132		TRUE	TRUE		1	23	54	132
3	1	4	14	7	8	54	132	200		FALSE	FALSE
4	7	1	14	7	23	54	132	200		TRUE	TRUE
5	4	5	14	7	23	54	132	200		FALSE	FALSE
6
7

<tbody>
</tbody>

 

[Cypress]

I tried the first solution you suggested. IFCOUNT
It worked perfectly.
Thank you very much for your quick response.

 

[navic]

You are welcome