Skip to content

Sample for custom_formula #594

@startupsandcode

Description

@startupsandcode

Would love an example on how to use a custom formula over a range dynamically.

Here is my "hypothesis":

sheet.add_conditional_formatting(
[2, 2],
[sheet.rows, sheet.cols],
"CUSTOM_FORMULA",
format={
"backgroundColorStyle": {
"rgbColor": {"red": 0, "green": 1, "blue": 0}
}
},
condition_values=['=if(isnumber(),1,regexmatch(,"\d"))']
)

I'm not sure how to reference the I inserted above as it formats a range.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions