activate font color not changing on multiple values selection

[#1]

i have a button which selects all values in country field ,i am setting action select in field  Country '(INDIA|US|UK*)',it selects correctly, but when i apply background color calculation on activation with if(Region='(INDIA|US|UK*)',LightRed(),black()),it does not work?? any idea

[Anonymous]

you Need to concat the regions and test to the result

if (concat(Region,'|')='INDIA|US|UK',LightRed(),...

when you select the regions with '(INDIA|US|UK*) each Region will be selected, bit not within 1 string

[#3]

thanx linder but still text color not changing

[Anonymous · Accepted solution]

sorry, I didnot try it

what i tried now works in my test

=if (GetFieldSelections(Region)='INDIA, US, UK',Lighred();..)

I guess there is a space between , and next character

and it might depend on the order how you select the regions (if you do by Action it should work)

[#5]

Color change also working for you?

[#6]

it works thanx a lot for the solution