Formatting Row rule in Basic Table

Question

Hi all,

I have a table that has negative numbers in parenthesis, and positive not. and they are all string fields. I want to color the negative numbers red and bold and positive black and bold. I'm not familiar with the syntax of formulas within a row rule... Currently I'm just coloring all of them red.

Attached is an example for the current situation.

Meiye

2023-11-06_13-31-03.png

Qiu · Accepted Answer

@Meiye

This is a very tricky one and I happened to know a trick for this 😂
I learned from this community and not able to trace back the original post.

If we apply the Row Rules, I believe we have to use all the Column Names in the conditional statement, which is not dynamic.

For Coumn Rule, it is also the same.
Unless we leave the option "Dynamic or Unknow Field" to do the trick.

For details, kindly refer below.