I have cells with formulas and want to add styles to the cells depending on the outcome (X) of the formula.
The condition for the formatting depends on comparison of X with values of other cells. Therefore I need to use X more than once to determine the formatting.
Example (with values instead of formulas and cell references and Red, Green being styles):
=2+STYLE(IF(AND(CURRENT()>1;CURRENT()<3);“Green”;“Red”)) does not work
How do I solve this?