get the conditional format object of the cell rangeĬom. The xSheet is the .XSpreadsheet interface of a spreadsheet. It uses the cell style "MyNewCellStyle" that is applied to each cell containing a value greater than 1.
![openoffice conditional formatting formula openoffice conditional formatting formula](https://img.brainkart.com/imagebk37/fasNo7O.jpg)
![openoffice conditional formatting formula openoffice conditional formatting formula](https://upload.wikimedia.org/wikipedia/commons/4/42/LibreOffice_7.2.4.1_start_centre_screenshot.png)
The following example applies a conditional format to a cell range. The method clear() removes all condition entries.The methods removeByIndex() removes the condition entry at the specified position.StyleName: The name of the cell style to apply.SourcePosition: A .CellAddress struct that contains the base address for relative cell references in formulas.Formula2 is used only if the property Operator contains BETWEEN or NOT_BETWEEN. Formula1 and Formula2: Strings that contain the values or formulas to evaluate.Operator: A .ConditionOperator constant describing the operation to perform.It expects a sequence of .PropertyValue objects. The method addNew() inserts a new condition.The interface .XSheetConditionalEntries inserts new conditions and removes them. The service .TableConditionalFormat contains all format conditions and returns .TableConditionalEntry objects.
![openoffice conditional formatting formula openoffice conditional formatting formula](https://openoffice.blogs.com/openoffice/images/calcconditional.gif)