Odd Conditional Format Question / Result

[Russ At Index]

Morning ,
I have a weird problem , which TBH i do not understand .
Cell range J2 thru O2 ..... so six cells containing :
[11] [Blank Cell] ,[Blank Cell] , [Blank Cell] , [Blank Cell] , [154]
My conditioning is set as :
Cell Contains = Blank Value - Colour Blue
Cell Contains = 0 - Colour Blue
Cell Value = Between 1 & 30 - Colour Red
Cell Value = Between 31 & 100 - Colour Amber
Cell Value = Greater Than 100 - Colour Green

The result is [11 Red] Correct
The following 4 cells should be Blue , they are Green
The last cell [154] should be Green & Is Green.

Can someone please help me with the blank cells , they should be blue but they are green ..... am i missing something ??

Many thanks ,

Russ.

 

[MARK858]

Try using Countif and Countifs to count the condition.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M		O	P	Q	R	S
1	285	106	73	52	209	207	29	69	213	154	91	17
2	46	118	25	263	47	185	28	264	50	93	161	242				1
3	115	117	52	124	220	178	17	228	149	280	65	29				0
4	240	87	26	299	244	218	55	118	8	133	22	245				36
5	230	46	213	224	92	104	261	206	161	5	131	294				69
6	200	279	0	294	192	117	210	228	121	124	197	128				194
7	147	95	141	83	37	83	300	175	70	153	220	138
8	181	110	92	147	48	299	261	252	91	280	126	257
9	76	241	53	47	81	266	113	20	110	1	276	27
10	100	129	133	248	28	186	265	199	19	219	156	29
11	87	296	1	279	248	56	120	11	138	258	181	215
12	110	211	108	274	131	14	29	283	247	191	104	28
13	94	95	23	83	205	1	259	186	258	281	115	91
14	12	40	85	134	127	18	103	159	243	73	249	143
15	233	181	90	252	137	128	198	46	258	176	223	11
16	59	62	226	283	16	174	283	239	207	40	94	56
17	110	241	36	24	159	296	152	80	154	285	274	275
18	300	21	135	34	151	177	103	292	271	63	60	162
19	238	274	252	162	41	157	92	201	163	177	68	293
20	217	268	81	276	234	205	276	201	225	132	146	219
21	171	18	29	40	264	246	150	281	69	83	195	218
22	138	255	238	216	92	175	34	155	59	101	110	236
23	181	128	57	65	167	285	169	43	223	111	1	48
24	210	161	264	77	194	247	54	242	20	174	5	243
25	134	100	49	190	54	238	72	52	23	115	10	187
Sheet1

Cell Formulas
Range	Formula
A1:L25	A1	=RANDBETWEEN(0,300)
P2	P2	=COUNTIF($A$1:$L$25,0)
P3	P3	=COUNTIF($A$1:$L$25,"")
P4	P4	=COUNTIFS($A$1:$L$25,">0", $A$1:$L$25,"<31")
P5	P5	=COUNTIFS($A$1:$L$25,">31", $A$1:$L$25,"<101")
P6	P6	=COUNTIF(A1:L25,">100")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:L25,N2:N6	Cell Value	=0	text	NO
A1:L25,N2:N6	Cell Value	between 1 and 30	text	NO
A1:L25,N2:N6	Cell Value	between 31 and 100	text	NO
A1:L25,N2:N6	Cell Value	>100	text	NO

Btw it would be much more helpful if you used the boards XL2BB addin rather than post images so we don't have to retype/makeup data.