Hello, I am trying to apply color to my list box items to show up in my worksheet. On the sheet that contains my list box I have formated the cells with different colors for each list item, but when I pick from the drop down list in my worksheet the color does not appear. What am I doing wrong? I do understand that the actual list box is not going to be in color, but when I choose from the list I want the color to appear on the spreadsheet.
Thanks in advance for your help.
Bren
Bookmarks