It's necessary for me, as well as others I'm sure, about conditional formatting where there is possibly no numeric value but Text. As well as being capable of applying conditional formatting based on...
It would be extremely helpful to have more control over conditional formatting. Specifying based on text (if value = apple then red, if value = banana then yellow, etc.) or based on a formula (if value > 100 then green else if value between 50 and 99 then yellow else red) that's in a different column.
