Format Rules

[alhazen]

Hi, I need your help.

I have a column named [_count_status] with sample values like 'Open (2)'. I want to create a format rule for the column where only the numbers inside the parentheses are colored. How do I write the formula for this condition?

[dbaum]

---

@alhazen wrote:

a format rule for the column where only the numbers inside the parentheses are colored

---

That's not possible. A format rule applies to the entire value, not a substring.

If formatting a substring is crucial, investigate  Rich Text Formatting - in Preview Program - Google Cloud Community .