<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Conditional Formatting equal works wrong" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132887#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Conditional Formatting equal works wrong" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132887">bug 132887</a> from <a class="email" href="mailto:ming.v.hua@qq.com" title="Ming Hua <ming.v.hua@qq.com>"> Ming Hua</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=160627" name="attach_160627" title="Screenshot of the "Urlaub" condition">attachment 160627</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=160627&action=edit" title="Screenshot of the "Urlaub" condition">[details]</a> Screenshot of the "Urlaub" condition (In reply to Alfredo from <a href="show_bug.cgi?id=132887#c4">comment #4</a>) > yes, this works, because I used the wrong rule to fix this issue. > > As you can see the rule is: Cell Value IS NOT EQUAL "u" -> this is wrong. > The rule should be: Cell Value IS EQUAL "u" I have no idea what you mean. In your example, the rule shows up as [equal to "u"] on my system, see attached screenshot. > If you open the document in Excel you can see that there it doesn't work. > The cell rage becomes yellow and when you enter "u" the cell get the > standard style format I don't have Excel to test, will have to wait for another tester.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>