Using AND in a formula to apply conditional formatting when a cell value falls in between 2 other values

[Snoogie2563]

I actually have a few questions, but I thought I would "dip my toe in the water as it where with this one.

I think my subject states what I'm after pretty clearly, but I would actually ultimately like to apply the formatting to a group of 5 adjacent cells in a row. I can get this to work fine if it's just one criteria like "$J(x)>90" or "$J(x)<=0". Where I'm running into problems is when I try and do something like this, "=$G2=AND(J2<=90,J2>30) which is supposed to apply my formatting when the value of J2 is between 30 and 90." If I try =AND(J2<=90,J2>30) it will format the first cell in the group I'm trying to do but not the whole group

 

[DanteAmor]

Hi and Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

Try:

Dante Amor
	A								I	J	K	L	M	N	O	P	Q
1
2										22
3										29
4										36
5										43
6										50
7										57
8										64
9										71
10										78
11										85
12										92
13										99
Hoja3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J2:P16	Expression	=($J2>=30)*($J2<=90)	text	NO

I don't know if you should include the value 30, if not then:

=($J2>30)*($J2<=90)

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------​

 

[Fluff]

Hi & welcome to MrExcel.
With your formula you need to lock the columns like

=AND($J2<=90,$J2>30)

 

[Snoogie2563]

Thanks to DanteAmor AND Fluff since you both said essentially the same thing. Locking the columns as suggested was the solution! Many thanks! The board wouldn't let me credit both as solutions.

 

[DanteAmor]

Everyone happy to help you, thanks for the feedback.