Is there a way to format text located throughout a table. For example, I have a vehicle inspection app with several columns with all of the same options, โRequires Attentionโ, Future Attention", Ok, N/A. When the app locates โRequires Attentionโ I would like that column to turn red, but I did not want to have to create a format rule for every column.
You donโt have to. The format rule applies to the table and you can then pick which columns will use that format rule
So I have to name every column? There are many columns
In order to format each column independently from the rest, yes, you need a separate format rule for each column.
If I were you, Iโd create a new Table to hold the dropdown choices, one per record. Then in your main Table, set the columns as Enum with โbase typeโ set as Ref, pointed to the new Table. Then you just need to create a single format rule per choice.
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |