Don’t be alarmed when it does this when you have chosen a relative hyperlink. To change the way that OOo saves the hyperlinks choose Tools > Options > Load/Save > General and choose if you want URLs saved relative to the File System, to the Internet, or both.Ĭalc always displays an absolute hyperlink. An absolute hyperlink says, “Here is how to get there from this known starting point” and a relative hyperlink says, “Here is how to get there starting from where you are now”. That's all - now the conditional formatting rule is activated for the entire column.Hyperlinks can be saved as either absolute or relative.

Set the cell range to apply the conditional formatting for an entire column, enter 'A:A'.īack in the 'Manage Conditional Formatting' window, select OK again. 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 -> 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.

Openoffice calc absolute reference