Highlighting Table Column or Row Based on External Data

[scsh4]

Hey guys! Maybe I'm too wrapped up in what I'm doing to see clearly, but here's where I'm stuck.

I have a table that shows account activity. For example:

Date	Time	Action	Account
2021-07-01	08:12:24	Update Field 1	Account 91515
2021-07-01	02:29:15	Update Field 23	Account 29493
2021-07-02	09:03:48	Update Field 15	Account 49583
2021-07-06	10:58:11	Update Field 1	Account 91515

In another table, I have certain accounts on a watch list. For example:

Account

Account 10010

Account 85000

Account 91515

Based on data, I would like the first table to appear as shown below, but am not sure how to reference the second data source when creating a column or row rule.

Date	Time	Action	Account
2021-07-01	08:12:24	Update Field 1	Account 91515
2021-07-01	02:29:15	Update Field 23	Account 29493
2021-07-02	09:03:48	Update Field 15	Account 49583
2021-07-06	10:58:11	Update Field 1	Account 91515

Any help is greatly appreciated!

[AdamR_AYX · Accepted solution]

I think the trick is to add a flag field which indicates the row rule but then deselect that for display in the table

Check out the attached

[atcodedog05]

Hi @scsh4 

Here another way to do it.

Workflow:

1. Using find & replace to lookup account and add the column if its present. Account2 will be added for present accounts. Find & replace works like excel vlookup

2. In table tool setting row rule where ever account2 is not empty make it red.

Hope this helps 🙂

[scsh4]

Thanks, @AdamR_AYX! I've used this method before and it escaped me. I appreciate your help!

[MeanLeanDean]

I have a column and row question. How can I highlight the max (or min) value of a row as in this example from Excel using the Table tool when the column headers dynamically change every month?