Get multiple values correct color

[fionna51]

Hi,

Some of our users can access multiple entities, we want to highlight (give different color) among all other entities. For example, when user entity is 1B then Rate 1B highlighted. But if user has two entities 1A and 1B (select 1A, 1B at same time), how to do the background color? Please see the attached app.

Thanks a lot.

[sunny_talwar · Accepted solution]

May be using this

If(SubStringCount(Concat(DISTINCT Security_Key), MEMID) = 1, RGB(20,255,255))

[fionna51]

Yes, this is working. Thank you.