Forum Discussion
contitional formatting with function IF
Hello, I´m trying color cells (Green-yellow-red) considering the value in it, for that, I added 3 rules, one colour each, but depending also from the sign in another cell. That means, if the sign i...
Alejandro1963 , in general formula works if you mean like this
Another story you will never check third condition (=) since you start from "greater or equal". Start checking from "equal" as in the second variant.
Hi Sergei,
Thank you for your time, as you said, the formula worked but searching why it didn´t I realised I wrote in two different ways the text to be compared, "≤ " didn´t match to "≤" because the first text on the column had a space-tab after the symbol and in the formula it didn´t have that space.
These hidden orthographic mistakes are to be taken into account.
Regards
Alejandro