I want to apply conditional formatting to column M based on the wavelength in column G. I do not want to compare it to the actual wavelength but a criteria based on the different wavelength. So 1310 would have have max value of .4500, 1550 would have have a max value of .2500 and 1625 would have a max value of .3500. I want any value in column M that exceed the max value of the wavelength of column G to turn red and any value that is equal to the max value or below turn green.
I was thinking an OR statement but cant find a configuration that works.
=OR(G2=1550 =< 0.2500, C2=1625 =< 0.3500) Green
=OR(G2=1550 > 0.2500, C2=1625 < 0.3500) Red
<tbody>
</tbody>
I was thinking an OR statement but cant find a configuration that works.
=OR(G2=1550 =< 0.2500, C2=1625 =< 0.3500) Green
=OR(G2=1550 > 0.2500, C2=1625 < 0.3500) Red
G | M | |
1 | Wavelength | Status |
2 | 1310 | 0.2011 |
3 | 1550 | 0.1916 |
4 | 1625 | 0.1984 |
<tbody>
</tbody>