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.
=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.