![]() 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. |