Just upgraded to to 4.0.2.2 from 3.6.5 and found that all the conditional formatting no longer works.
The main one I use is:
[RED]0.0;[BLUE]0.0
This went wrong in the past got fixed and appears to have failed again?
Is there a fix? or do I need to revert back to version 3?