Background Color arrangement

[Learnerr]

Hi experts,

I would like arrange the background color of my dimension. I need to say my If clause to look for 2 fields but i cannot write the proper way of it. How can i arrange my if clause please?

=if(Exclusive_Tanim='STRW-DÜZ and Exclusive_Tanim=STRW-DEKOR', rgb(255, 0, 0),rgb(0, 128, 0) )

Have a nice day!

[marcus_sommer · Accepted solution]

Syntax and logic aren't quite right. Try it instead with:

=if(match(Exclusive_Tanim, 'STRW-DÜZ', 'STRW-DEKOR'), rgb(255, 0, 0),rgb(0, 128, 0) )

- Marcus

[Learnerr]

Thanks,it works.

Have a nice day!