![]() ![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |