Conditional format based on value in another cell being between two numbers

[supermom28115]

This is probably simpler than I am making it because I have several tables set up to highlight certain cells based on what number the day is and if it matches the assigned day so I am sure you guys will be able to answer this quicker than I can erase the formula that doesn't work.
B15 needs to be highlighted if H5 value is between 135 and 149.
Thank you guys for all your help on the boards. I don't post often because I can usually find the answer or figure out my mistake from other answers and don't need to post when I am stuck. I am very grateful that this resource is available when I have questions.

 

[etaf]

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
B15 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND(H5>=135, H5<=149)

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Book1
	A	B	C	D	E	F	G	H
1
2
3
4
5								140
6
7
8
9
10
11
12
13
14
15
16
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B15	Expression	=AND(H5>=135, H5<=149)	text	NO

 

[supermom28115]

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
B15 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND(H5>=135, H5<=149)

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Book1
	A	B	C	D	E	F	G	H
1
2
3
4
5								140
6
7
8
9
10
11
12
13
14
15
16
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B15	Expression	=AND(H5>=135, H5<=149)	text	NO

It took me a minute to get my file uploaded at home but I finally was able to use your formula and it was exactly what I needed. Thank you for your help.

 

[etaf]

you are welcome