I have a list box on a userform, that has 4 columns 1 text and three numeric. Would like to format the columns so that the text is left aligned and the numeric columns are right aligned.

Also would like to change the color of rows with negative numbers.

I've searched this forum and found the question many times but no anwsers were posted. Is it impossible?
Or is there away I could display part of the worksheet on the userform?

Fraz627