Highlight cells according to a input list file

Question

hi all, please help and advise if you have any solution on below? Thanks!

Dataset:

NameAmy

BenCelia

DaisyElleForestGeollenHailyImmyJackKen

A separate name list file (will be updated from time to time):

Highlight NameBenCelia

ElleGeollenImmyKen

Expected Result:

Can I setup any format rule to reach the below goal? Thanks!

NameAmy

BenCelia

DaisyElleForestGeollenHailyImmyJackKen

binu_acs · Answer

@Riiiiita another approach

text_color_23082024.yxmd

apathetichell · Answer

two file browse tools (if needed) - one for full dataset - one for match file.

join tool.

formula tool to join - create new field Green - give it an int value of 1

anchor of your full data set unjoined - create new field Green give it an int value of 1.

union

table tool

highlight your name column (or whatever) - create a column rool.

column rool applies when Green ==1

set text color = green

use render to output.

Green.yxmd

Gawa · Answer

@Riiiiita You can utilize "Column Rules" option in the Table tool.

In your case, you need to highlight the users that exists in the "Highlight Name", then you can Left Outer Join "Name" and "Highlight Name" and put flag for matched users. And, by using that flag as conditional formatting in the above said option, you can change font as you wish.

FYI, I'm attaching WF. You can use it for your reference.

1310051.yxmd