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

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,215,200
Messages
6,123,601
Members
449,109
Latest member
Sebas8956

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