The Preview box shows how the cell will look like after formatting.

Use the General drop-down list to choose the appropriate number format (General, Number, Scientific, Accounting, Currency, Date, Time, Percentage). You can choose one of the available format PresetsĬustomize the formatting using font format options (Bold, Italic, Underline, Strikeout), Text color, Fill color and Borders. The Format section offers a range of cell formatting options.Use the reference to a single cell, or the reference with the worksheet function such as =SUM(A1:B5). Use the Select Data box to define the cell value to compare with. The Rule section shows the selected rule and the selected comparison condition, by clicking the down arrow you can access the list of the available rules and conditions.The Value is formatting rule is used to find and highlight cells meeting a certain comparison condition: The New Formatting Rule window will open for you to format the highlighting criteria. To apply a formatting rule condition, select the cell range then click the Conditional formatting button on the top toolbar, or click the Conditional Formatting control of the Cell Settings tab on the right sidebar, and choose the appropriate rule from the drop-down menu. To open the New Formatting Rule window, you can right-click any cell and choose Conditional Formatting from the contextual menu. Click the Conditional Formatting control down arrow to open the drop-down menu containing all the available options. Īll Conditional Formatting options are also available on the right sidebar in the Cell Settings tab.

Value is, Top/Bottom, Average, Text, Date, Blank/Error, Duplicate/Unique, Data Bars, Color Scales, Icon Sets, Formula.įor quick access, or if you want to choose one of the available preset conditions, or to access all the available conditional formatting options go to the Home tab and click the Conditional formatting button. Specify the fit for purpose criteria and create new formatting rules, edit, manage or clear the existing rules.Ĭonditional formatting rules supported by the ONLYOFFICE Spreadsheet Editor are: Conditional formatting allows you to apply various formatting styles (color, font, decoration, gradient) to cells to work with data on the spreadsheet: highlight or sort through and display the data that meets the needed criteria.

Openoffice calc highlight duplicates