Conditional Formatting of one range of cells based on another range of cells

[Mr_Phil]

My mind isn't wrapping around why this isn't working.

I need to change the format of B8:F8 if O913 does not equal zero.
To be clear B8 only looks at O9, c8 looks at o10, ... f8 looks a o13

I told my friend "sure I can help". And now I can't seem to make it work. Not getting it.

I did the rule as o9 <> 0 and B8 changed format but it won't copy across.

 

[Eric W]

Try:

Book1
	B	C	D	E	F	G								O
8	a	b	c	d	e
9														1
10														2
11														0
12														0
13														3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B8:F8	Expression	=INDEX($O$9:$O$13,COLUMNS($B:B))<>0	text	NO

 

[Peter_SSs]

Not important but the "<>0" comparison should not be needed.

24 03 02.xlsm
	B	C	D	E	F	G								O
8	a	b	c	d	e
9														1
10														2
11														0
12														0
13														3
CF not 0

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B8:F8	Expression	=INDEX($O$9:$O$13,COLUMNS($B:B))	text	NO