how do you have the second cell condition in effect and disregard the first cell condition when the value of the second cell condition is met in Market analyzer to color code cells?


for example; value > 90 turn red, value > 97 turn orange, value < 10 turn green, value < 5 turn lime

google conditional formatting

mystiq 

how do you have the second cell condition in effect and disregard the first cell condition when the value of the second cell condition is met in Market analyzer to color code cells? for example; value > 90 turn red, value > 97 turn orange, value < 10 turn green, value < 5 turn lime

:found answer: just arrange the order for the conditions to apply