Sort the list box as Red,Yellow,Green!

[#1]

Hi Friends

I have added a list box which contain three text "Red, Yellow & Green".

Currently it is apprering as "Green,Red,Yellow"  I want it to appear as "Red,Yellow,Green" (RYG)

It works, if you change sort option as Load order & if the excel input order is RYG, but in my case this order will change always.

Please help!

Enclosed is the file.

Thanks in advance for your help!

Regards

Rahul

[swuehl · Accepted solution]

Try a sort expression in sort tab:

=match([St Color],'Red','Yellow','Green')

with order ascending.

[#3]

Thanks Swuehl!

It works!!