![]() Set the cell format to apply if condition is true Set the condition (in my example: apply format if cell value > 3, alternatively, select "Formula is" instead of "Cell value" and add your formula in the adjacent field). In the "Manage Conditional Formatting" window, select Add ![]() To set the conditional formatting for an entire column in LO Calc Version 7, proceed as follows: Update for LibreOffice 7 (tested with 7.1.3) So, LibreOffice translated the conditional format defined for the complete table in single rules for each of the cells automatically. You will see there's a conditional formatting rule defined for that cell, with Formula is as condition type, and $B4 > 2 as formula. To double-check what LibreOffice / OpenOffice did with your table, select a single cell, for example A4, and select Menu Format -> Conditional Formatting -> In the above, that's row 1, but if there were a row of headers above it and so your selection started on row 2 (leaving out the headers), you'd use $B2 > 2 as the formula (rather than $B1 as above). Note: The row number you use in the formula should match the number of the first row you've selected. Select Menu Format -> Conditional Formatting ->Įnter as Formula $B1 > 2 and set the format to be applied if condition matches (for example, ugly red background) ![]() '$D5'), OpenOffice will adapt it for every selected cell.įor example: You want to conditionally format the following table based on the value of the second (B) column (format should be applied if value is greater than 2): Now, if your formula uses a cell address with fixed column (e.g. Just select all the cells that should get conditionally formatted, and use a formula-based rule. You don't need to select the cell that holds the value that should be relevant for conditional formatting. ![]()
0 Comments
Leave a Reply. |