Seriously! I tell you, anyways, the scenario would look something similar to this one.
i. If A1 = 1, then colour 1 is applied is applied to A3 -->ok.
ii. If A2 is changed to -1, then A3 becomes -10, but colour 1 is still applied to A3 -->incorrect. Selecting "Apply" in the Conditional Formatting Manager will apply the correct colour, though.
iii. If you enter -20 in A3 manually (i.e. you override the formula), then colour 2 is applied -->ok.
So, the issue appears to be with re-evaluating the formatting applied to formula-results.
Bookmarks