Conditional Formatting between 2 values and out of 2 values

Lynsvyr

New Member
Joined
May 11, 2022
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
For green I need the value of PPA Rate to be between the 2 values and red if not. So far this is what I'm using:
=AND(H21>=$R$21, H21<=$S$21) - Green
=$R21<>$S21 - Red

However the values are not aligning and overriding each other. Previosuly I just created a formula for each row on there own but am trying to condense so I only have 2 formulas instead of creating 3 for each cell.
In this we can see that the 225 is green like it should be, but the next row despite being between the next set of values is red like it's taking the info from the first row. Not Sure where I'm going wrong with this.
 

Attachments

  • MrExcel.png
    MrExcel.png
    10.2 KB · Views: 17

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,224,824
Messages
6,181,186
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top