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?
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?
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 .