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))

[sinanozdemir]

Try it like the below:

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

Hope this helps

[Anonymous]

thanks for the reply but it is not working

[krishnacbe]

Share some sample data or app. so that we can help you better

[krishnacbe]

If there are more that one possible values for [Tree Name Group], then your expression will not work.

[Anonymous]

yes,there are more that one possible values for [Tree Name Group. So, what should I do instead?

[Mark_Little]

Hi,

Not sure where you are doing this, but if i was writing it would just do it like

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

Mark

[Anonymous]

Hi Mark,

thanks for your help. this is where I am doing this:

[antoniotiman · Accepted solution]

Hi,

try

If(Match([Tree Name] , $(=Concat(DISTINCT Chr(39)&[Tree Name Group]&Chr(39),','))), RGB (128,0,0),RGB(0,0,0))

Owever this works if [Tree Name] -> 1 Value

Regrds,

Antonio

[Anonymous]

It is still not working