Conditional formatting formula

[Yamasaki450]

Hey everyone i need some help with formulas.

I need conditional formatting formula to highlight specific range of numbers in specific row.

I would like to highlight all numbers from (-4 to 65) in rows where number 3 is in column C.
So in this case all numbers from (-4 to 65) in range E4:T4 and E7:T7 are highlighted red.

See screenshot... i did this manually for row 4 and 7 which have number 3 in column C.

 

[awoohaw]

You can try this:

Mr Excel Questions 75.xlsm
	A	B	C	D	E	F	G	H
1
2	29	-40	-3	-6	12	22	-8	-31
3	17	97	3	77	87	23	28	61
4	57	85	3	90	25	14	89	8
5	-17	83	2	87	63	71	22	58
6	85	-47	0	81	60	-16	-3	74
7	-38	-32	-4	-39	-3	77	49	83
8	-4	-5	2	92	-36	84	35	47
9	41	61	-4	86	59	74	95	-32
10	-27	88	1	95	65	30	-20	83
11	37	39	0	94	-25	-33	99	8
12	64	93	3	-30	43	97	-48	-42
13	-19	84	3	57	64	58	66	-31
14	87	83	-3	-33	59	37	-34	38
15	-23	-40	3	-39	40	-14	-30	42
16	93	0	3	55	42	-38	57	88
Sheet13

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:H16	Expression	=AND($C2=3,D2>=-4,D2<=65)	text	NO
A2:B16	Expression	=AND($C2=3,A2>=-4,A2<=65)	text	NO

 

[Yamasaki450]

You can try this:

You can try this:

I had to adjust formula a bit for my needs... But it works great. Thanks for your help.

 

[awoohaw]

Great, happy to help. Best Wishes!

 

[Yamasaki450]

Great, happy to help. Best Wishes!

One more question.

Formula doesnt work if i change it from =AND($C2=3,D2>=-4,D2<=65) to =AND($C2=3,D2>=-4,D2<=-65) So highlight numbers from -4 to -65

Any idea how to fix this?

 

[Peter_SSs]

Formula doesnt work if i change it from =AND($C2=3,D2>=-4,D2<=65) to =AND($C2=3,D2>=-4,D2<=-65) So highlight numbers from -4 to -65

=AND($C2=3,D2<=-4,D2>=-65)

 

[Yamasaki450]

=AND($C2=3,D2<=-4,D2>=-65)

Great... Now it works. Thanks.

 

[Peter_SSs]

You are welcome. Thanks for the confirmation.