changing the text color using IF & match

[Anonymous]

Hi,

the following code is not working, what can I do to get it to work?

=if(match([Tree Name],[Tree Name Group]), RGB (128,0,0),RGB(0,0,0))

[Anonymous]

sorry, no joy, still not working

[antoniotiman]

Hi,

The first paramether of Match() function must have 1 value.

If [Tree Name] has many values it is Null().

You can try MinString([Tree Name]) or MaxString(), but I'm not sure this is what Your expecting result.

[antoniotiman]

Try

WildMatch($(=Concat(DISTINCT [Tree Name],'')) , $(=Concat(DISTINCT Chr(39)&Chr(42)&[Tree Name Group]&Chr(42)&Chr(39),',')))

Instead of Match() expression

[Anonymous]

sorry still not working

[antoniotiman]

I'm sorry, this is the best I can do with Match/WildMatch.

If You want uncheck "Correct Answer" and You hope someone else You provides correct answer.

Regards,

Antonio

[sunny_talwar]

How about this:

If(Count({<[Tree Name] = p([Tree Name Group])>} [Tree Name]) > 0, RGB(128,0,0), RGB(0,0,0))

[Anonymous]

thanks for trying but I don't know why it is not highlighting the names in red

[Anonymous]

thanks