Highlighting cells based on sum of another cell

[jojo1215]

I am looking to highlight a row(bolded items) if the variable below is >= and <=. Any input or direction to a link for assistance would be appreciated.
						Variable
							3
Basic	3		>=0<=3
Standard	10		>=4<=10
Standard Plus	15			>=11<=15
Extreme	40			>=16<=40
Extreme Plus	55			>41<=55
Business	75			>=56<=75
Business Plus	100			>=76<=100

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col></colgroup>

 

[Joe4]

Welcome to the Board!

So, in your example, since the value is "3", are you looking to highlight the "Basic" row?

Let's say that the variables is in cell C1. Then, to set up Conditional Formatting, select the "Basic" row, and use this Conditional Formatting formula:

=AND($C$1>=0,$C$1<=3)

and choose your formatting color.

Then, select the "Standard" row, use this CF formula:

=AND($C$1>=4,$C$1<=10)

and choose your formatting color.

Repeat this process/pattern for the rest of your rows.

 

[jojo1215]

Welcome to the Board!

So, in your example, since the value is "3", are you looking to highlight the "Basic" row?

Let's say that the variables is in cell C1. Then, to set up Conditional Formatting, select the "Basic" row, and use this Conditional Formatting formula:

=AND($C$1>=0,$C$1<=3)

and choose your formatting color.

Then, select the "Standard" row, use this CF formula:

=AND($C$1>=4,$C$1<=10)

and choose your formatting color.

Repeat this process/pattern for the rest of your rows.

Yes sir that is correct fir your bolded question above...

When I did this under conditional formatting, I selected new rule and copied and pasted the formula you mentioned in response. It just seems to highlight the "Basic row" and no others. Am I selecting from the wrong area?

 

[Joe4]

When I did this under conditional formatting, I selected new rule and copied and pasted the formula you mentioned in response. It just seems to highlight the "Basic row" and no others. Am I selecting from the wrong area?

Do you mean as your change the value, it does not highlight any other rows?
Did you miss this part of my original reply?

Repeat this process/pattern for the rest of your rows.

Note that I only gave you the first two rules. You need to follow the same pattern with the other rows.
So, each row will have its own Conditional Formatting formula.