![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |