https://bugs.documentfoundation.org/show_bug.cgi?id=159167
Heiko Tietze <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |87351 CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org |tion.org OS|Windows (All) |All Ever confirmed|0 |1 Status|UNCONFIRMED |NEW Summary|Conditional formatting of |Check whether formula in |cells based on rules for |conditional formatting are |checking values greater |valid |than or less than | Keywords|needsUXEval | --- Comment #16 from Heiko Tietze <[email protected]> --- (In reply to Rafael Lima from comment #5) > AFAIK it is not possible to define a conditional formatting rule where the > condition is a range. I wouldn't expect a range for simple comparisons like "is equal to" but when it comes to "is in top N elements" the situation is less clear. https://help.libreoffice.org/24.2/en-US/text/scalc/01/05120100.html > It has to be either a single cell or the result of a formula. Using MIN(A$1:A$2) as suggested in comment 3 works well. The issue was that "$Tabelle1.$A$2:$E$2" is not a formula; less than a range does not compute. Nevertheless I agree with room for improvement. If a function does not return a simple value like A1:A2 or MIN() without parameter, it should trigger a warning and not become accepted. I'll change the summary accordingly. If you disagree, Alexander, feel free to revert. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=87351 [Bug 87351] [META] Conditional formatting bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
