axisnsa.blogg.se

Select Menu Format -> Conditional Formatting -> Manage.Į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.