Change back color of List Box dependent on value.

Help!

I have 2 variables which import into a listbox from an excel page.

I would like the background colour to change dependent on the text in the Listbox.

The two variables are Gain and loss.

If the word gain appears in the listbox I would like the back ground colour to be Green
and if the word loss appears in the listbox I would like the background colour to be red.

I am very rusty with VBA and am struggling to make this happen.

My feeble attempt so far is as follows:

Please Login or Register  to view this content.

Any ideas?

Thank you in advance.

Again this is my poor knowledge. If there is a better way to display data on the userform I am all ears!