Difficult conditional formatting

[motilulla]

Hello,

I got 4 different scenarios
Seenario1-in column C got 2 number separated by vertical bar with
Seenario2-in column E got 3 number separated by vertical bar with
Seenario3-in column G got 4 number separated by vertical bar with
Seenario4-in column I got 5 number separated by vertical bar with

I need to get highlighted the numbers that contain "0" in any positions

Like this...

Book1
	A	B	C	D	E	F	G	H	I	J
1
2
3
4
5			2 Num		3 Num		4 Num		5 Num
6			0|0		0|0|0		0|0|0|2		0|0|0|2|1
7			2|0		2|0|0		2|0|0|1		2|0|0|1|0
8			1|0		1|0|0		1|0|0|0		1|0|0|0|1
9			3|0		3|0|1		3|0|1|2		3|0|1|2|0
10			2|1		2|1|0		2|1|0|2		2|1|0|2|1
11			2|1		2|1|2		2|1|2|1		2|1|2|1|1
12			2|1		2|1|2		2|1|2|1		2|1|2|1|0
13			1|2		1|2|0		1|2|0|1		1|2|0|1|1
14			1|2		1|2|1		1|2|1|2		1|2|1|2|1
15			2|1		2|1|1		2|1|1|0		2|1|1|0|0
16			1|0		1|0|2		1|0|2|2		1|0|2|2|2
17			1|1		1|1|1		1|1|1|2		1|1|1|2|2
18			1|1		1|1|1		1|1|1|1		1|1|1|1|2
19			2|1		2|1|1		2|1|1|1		2|1|1|1|1
20			2|2		2|2|0		2|2|0|1		2|2|0|1|1
21			2|2		2|2|1		2|2|1|2		2|2|1|2|0
22			2|2		2|2|1		2|2|1|1		2|2|1|1|1
23			1|1		1|1|3		1|1|3|0		1|1|3|0|1
24			1|0		1|0|2		1|0|2|2		1|0|2|2|2
25			1|0		1|0|1		1|0|1|2		1|0|1|2|1
26			3|1		3|1|1		3|1|1|3		3|1|1|3|1
27			2|1		2|1|1		2|1|1|0		2|1|1|0|1
28			2|0		2|0|0		2|0|0|1		2|0|0|1|1
29			2|1		2|1|2		2|1|2|0		2|1|2|0|2
30			0|2		0|2|0		0|2|0|1		0|2|0|1|0
31			2|1		2|1|0		2|1|0|0		2|1|0|0|0
32			0|1		0|1|1		0|1|1|1		0|1|1|1|0
33			0|1		0|1|2		0|1|2|3		0|1|2|3|2
34			0|1		0|1|3		0|1|3|0		0|1|3|0|0
35			2|1		2|1|2		2|1|2|0		2|1|2|0|1
36			2|0		2|0|0		2|0|0|2		2|0|0|2|1
37			0|1		0|1|2		0|1|2|1		0|1|2|1|1
38			1|1		1|1|1		1|1|1|2		1|1|1|2|0
39			1|2		1|2|1		1|2|1|3		1|2|1|3|0
40
41
42
Sheet1

Please help with conditional formula for each column separately

Thank you all
Excel 2000
Regards,
Moti

 

[Fluff]

Use Formulais & =FIND("0",C1)>0

 

[motilulla]

Use Formulais & =FIND("0",C1)>0

Wow!! Fluff, can't believe your formula is working for all columns like magic

Thank you so much for you help

Have a good day

Good luck

Kind Regards,
Moti

 

[Fluff]

Glad to help & thanks for the feedback