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: 4

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,216,025
Messages
6,128,336
Members
449,443
Latest member
Chrissy_M

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