I'm trying to find out why my 2nd conditional formatting does not work.
Basically on my sheet there is a column where the pH must be greater than 6.5 and less than 8.5 (Looks like 6.5 > pH < 8.5)
The conditional formatting is applied to the next column over for the sake of simplicity lets say this is column B which has its own IF statement to print out OK if true, Bad if False
So my first one I wrote it like this:
=AND(A5>=6.5,A5<=8.5) and this will set the cell colour to green if I put in say 7 for pH, this is applied to Column B starting @ B5
The second one I wrote it like this:
=AND(A5<6.5,A5>8.5) and its supposed to set the colour to red, this also applies to Column B starting @ B5 however, I think there is something wrong with the logic on this one which is maybe why it doesn't work.
Basically on my sheet there is a column where the pH must be greater than 6.5 and less than 8.5 (Looks like 6.5 > pH < 8.5)
The conditional formatting is applied to the next column over for the sake of simplicity lets say this is column B which has its own IF statement to print out OK if true, Bad if False
So my first one I wrote it like this:
=AND(A5>=6.5,A5<=8.5) and this will set the cell colour to green if I put in say 7 for pH, this is applied to Column B starting @ B5
The second one I wrote it like this:
=AND(A5<6.5,A5>8.5) and its supposed to set the colour to red, this also applies to Column B starting @ B5 however, I think there is something wrong with the logic on this one which is maybe why it doesn't work.
Last edited: