https://bugs.documentfoundation.org/show_bug.cgi?id=146790
--- Comment #8 from ady <adylo811...@gmail.com> --- (In reply to Eike Rathke from comment #7) > What actually is the problem? STR: 1. Open attachment 177583 from comment 2 2. [CTRL]+[SHIFT]+[F9] repeatedly until some numeric values in column D have their background color changed according to their conditional format. Step 2 might take several tries, but it will happen eventually. The BG color in column D shows repeating values, which in theory would only happen when there are repeating values in column A too, but it is clearly not always the case in attachment 177583. Thus, it would hint at some problem in COUNTIF(). I tried replicating the same situation with column A being integers (instead of [0...1], and it was clearly less likely to happen. So, is this because natural accuracy issues? IDK. (FWIW, bug 151958, also related to COUNTIF() doesn't seem to be related to accuracy.) -- You are receiving this mail because: You are the assignee for the bug.