Hi, is there any way possible to put conditional formatting on each item in a list?
Like the example below, let's say I would like to have [Instock] Status to be blue, [Payable] to be red, etc.
The column is currently a list of text.
Click Views > Format Rules. You can then show specified text in specified colors.
What I want is [In Stock] , [Payable]
Rule name = Set to Red
For this data = <tablename>
If this condition is true = use expression to define if the formatting only applies in a particular view (eg: IN(CONTEXT("View")) = "<viewname>")
Format these columns = select [In Stock]
Visual format > Text color: select blue
Save
Repeat for red.
I understand the basic of conditional formatting.
Well, let me elaborate this further.
My [Status] column is a list type that contains lists of text.
In this case, some rows contain multiple status like {"In Stock" , "Payable"}.
What I need is to format each element of the list individually like my example above.
The output should look something like this:
Status
In Stock , Receivable
Depleted
In Stock , Payable
Payable , Receivable
Is this possible in anyway? Thanks.
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |