https://bugs.documentfoundation.org/show_bug.cgi?id=139649
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|NEW |RESOLVED --- Comment #6 from Mike Kaganski <[email protected]> --- This is not a bug. In attachment 168913, the conditional formatting rule is exactly > Cell value - Is less than - $'1'.$G$2:$G$13 And the range, that this conditional formatting applies to, is F2:F13. You could imagine, that in this case the same "by intersection" rules would apply, and for each cell in the range, the respective cell in $'1'.$G$2:$G$13 will be picked. But it is not the case for conditional formatting. When you define conditional formatting, you always work as if you are working with a single cell, which is the topmost leftmost (in LTR) cell of the range. The conditional format will be compiled for that case. This means, that your condition converts to "apply this format, when the value is less than the *absolutely-referenced* cell obtained by intersection of F2 and $'1'.$G$2:$G$13", which is exactly one fixed cell, $'1'.$G$2. This is the value, that all the cells in the range are compared to. You don't need to provide the G2:G13 range at all; and you definitely don't want to use absolute addressing here. What you need is a formula, that would read "compare to a cell that is same row, next column" - which, for F2 (the top left of your "apply to" range) is "Cell value - Is less than - G2". So instead of "$'1'.$G$2:$G$13", you only need "G2". Note that this works exactly the same way in e.g. MS Excel. -- You are receiving this mail because: You are the assignee for the bug.
