title: “Working with Excel Conditional Formattings” second_title: “Document” linktitle: “Conditional Formattings” type: docs url: /conditional-formattings/ aliases: [/working-with-conditional-formatting/] keywords: “Excel, conditional formatting, spreadsheet, Cells.Cloud API, REST API” description: “The Cells.Cloud API for Excel provides endpoints to retrieve, add, modify, and clear conditional formatting rules, enabling dynamic visual analysis of worksheet data.” weight: 100

    Conditional formatting in Excel enables you to highlight cells with a specific color, depending on the cell’s value.

    Use conditional formatting to help you visually explore and analyze data, detect critical issues, and identify patterns and trends.

    Conditional formatting makes it easy to highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data by using data bars, color scales, and icon sets that correspond to specific variations in the data.

    A conditional format changes the appearance of cells based on the conditions you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range remains unchanged. There are many built‑in conditions, and you can also create your own (including by using a formula that evaluates to TRUE or FALSE).

Summary

• Get Conditional Formattings of Worksheet
• Get Conditional Formatting
• Add a Cell Area for Format Condition
• Add a Condition for Format Condition
• Add a Format Condition
• Clear All Condition Formattings
• Remove Cell Area from Conditional Formatting
• Remove Conditional Formatting