Update conditional format rule

googleSheets.updateConditionalFormatRule() completely replaces a rule at one sheet’s zero-based index without moving it.

Example

import { automation, onDashboardRun } from "automate.ax"
import { googleSheets } from "automate.ax/google-sheets"

export default automation("Update order highlighting", () => {
  onDashboardRun({ title: "Update order highlighting" })

  googleSheets.updateConditionalFormatRule({
    spreadsheet: "spreadsheet-id",
    sheet: "Orders",
    index: 0,
    ranges: [{ sheet: "Orders", startRow: 2, startColumn: 3 }],
    rule: {
      type: "boolean",
      condition: { type: "textEqual", value: "Overdue" },
      format: { bold: true, backgroundColor: "#FCE8E6" },
    },
  })
})

Inputs

Provide spreadsheet, sheet, zero-based index, complete replacement ranges, and a complete replacement rule. All ranges must resolve to sheet. See Create conditional format rule for range targets, conditions, gradients, strict colors, and supported conditional-format properties. Table targets resolve to fixed grid ranges at update time. Rule indexes are per sheet and can shift after other rule lifecycle operations. Second argument { account } selects the Google Account. All action inputs accept compatible signals.

Output

Returns the updated { index, ranges, rule } with normalized zero-based ranges.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Update conditional format rule

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output