Skip to main content
Call this API to create a conditional formatting rule in a specified Worksheet of a DingTalk Spreadsheet. The rule automatically applies highlighting styles based on cell values or duplicate status. This is useful for scenarios where data needs visual marking — for example, highlighting cells below a target value in red, highlighting duplicate entries for easy review, or distinguishing values within a specific range with a designated background color. Once the rule is created, cells that meet the conditions will automatically apply the specified font color or background color, eliminating the need to set each one manually.

Request

Basic information

Request header

Path parameter

Query parameter

Request body

Request example

HTTP
Java
Python
PHP
Go
Node.js
C#

Response

Response body

Response body example

Error codes

If an error occurs when calling this API, look up the error message in the Global error codes documentation for a solution.