Conditional formatting allows you to automatically change the appearance of cells depending on the values they contain.
When you paste content from the clipboard within the editor, the conditional formatting of the cell is not retained.
The Clear all and Clear formatting commands remove conditional formatting rules.
Conditional formatting is not supported for pivot table cells.
Specifics of support for conditional formatting created in third-party editors:
–You can open and save conditional formatting for rules of the Icons type. However, reading individual icons for each condition when creating a conditional formatting rule based on icons is not supported. Separately configured icons will be displayed as icons of the first subrule.
–Unsupported cell fill (pattern) will not be displayed.
–Backward compatibility with Excel is not supported for documents in .ods format. Documents in .ods format created in MyOffice Spreadsheet may not contain conditional formatting rules when opened in Excel. Documents in .ods format created in Excel may not contain conditional formatting rules when opened in MyOffice Spreadsheet.