https://bugs.documentfoundation.org/show_bug.cgi?id=119421
Roman Kuznetsov <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Roman Kuznetsov <[email protected]> --- There is Conditional Formatting Guide https://wiki.documentfoundation.org/images/d/d1/LibreOffice_Calc._Conditional_formatting_guide_EN.pdf Part 6.3 is about Formula is condition: In this category you enter a formula in special field. By using formulas you can realize any condition from “Cell value is” category and any from your own condition. The style is applied to the cell if value in cell corresponds to the result of the formula. You can use all functions in your formula, that are present in Calc. For example, for cell range (А1:А10) you can use this formula: А1=340, or А1<100, or А1<>”USA”, or А1=”Contract is in work”. In this case cell A1 and next cells from range will be checked by the corresponding result of the formula. This category is one that allows to apply conditional formatting to cell or cell range not matching with cell or cell range in condition. In this case you should use the sign $ in cell address in the formula. In spreadsheets, sign $ allows to fix cell or column number (or both) when you copy the formula in to another cells. Let’s see several examples: Task: it is needed to highlight cell range B1:G1 by green color, if value in cell А1 equal to 100 (that is it needs to highlight row from the right of the checked cell). Solution: enter a formula as $А1=100 and cell range as B1:G1. If you don’t write $ sign in the formula, then Calc will not highlight all B1:G1 range by green color, but will highlight only cell B1. Task: it is needed to highlight cell range A2:A10 by green color, if value in cell А1 equal to 100 (that is it needs to highlight column below of the checked cell). Solution: enter a formula as A$1=100 and cell range as А2:А10. If you don’t write sign $ in formula, then Calc will not highlight all range А2:А10 by green color, but will highlights only cell A2. Notice where the $ sign is in each case. For cell range as B2:F20 in this case you should use the sign $ in formula as $A$1. So we just can add that info to our Help -- You are receiving this mail because: You are the assignee for the bug.
