![openoffice conditional formatting drag and drop openoffice conditional formatting drag and drop](https://wiki.openoffice.org/w/images/0/07/DG4-25.png)
![openoffice conditional formatting drag and drop openoffice conditional formatting drag and drop](https://i.stack.imgur.com/ujy07.png)
If you select cell value is, the Cell Value Condition box is displayed, as shown in the example. You can move the Styles and Formatting window to a convenient position on the screen or dock it to an edge. Specifies whether conditional formatting is dependent on a cell value or on a formula. To open the Styles and Formatting window, do any one of the following: Click on the icon located at the left-hand end of the object bar. For example, in a table of numbers, you can show all the values above the average in green and all those below the average in red. You can set up cell formats to change depending on conditions that you specify. These modifications do not change the theme they only change the appearance of this specific spreadsheet document. If you wish, you can now go to the Styles and Formatting window to modify specific styles. As soon as you select a theme, some of the properties of the custom styles are applied to the open spreadsheet and are immediately visible.