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. But if you do it like this, it will adjust each formula to match the current cell as you require.It's even easier than pnuts' solution. I found the only thing that worked for me was to drag top-left to bottom-right across the cells, and then enter the value of the bottom right cell in the formula (in this case 'F13'). 'F13') is also not particularly logical, the cell you have to put in here depends on how you dragged out the selection on the cells before selecting 'conditional formatting'. So to match the word 'yes' anywhere in a cell's text content, you could use:
The open office help says that COUNTIF uses regular expressions for matching the text - hence the '.*' before and after the 'P' (when looking for cells that only contain an exact phrase match i've had mixed success with a straight "P" test - it seems to work in conditional formatting formulas, but not in cells). This tests for the character 'P' anywhere in the text of each cell in turn. I'm sure there must be an easier way, but here's what I came up with to test a cell to see if it contains a text string value in conditional formatting:
0 kommentar(er)
