List Box Formats

**JBC** · 09-10-2009, 04:28 PM

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

**martindwilson** · 09-10-2009, 09:38 PM

example workbook please ?

**JBC** · 09-11-2009, 03:10 PM

Thanks for your help. The example is the shifts some display on the schedule in color but the others do not. Thanks in advance for your help.

**martindwilson** · 09-12-2009, 06:35 AM

which tab,which cell? what condition?

**JBC** · 09-12-2009, 09:10 AM

I would like for the sheet "Schedule" in columns Monday-Sunday cell C8.I41 when I select the list box "Shift" to appear in color. On the sheet "Shifts" cells A3-A20 and cells A25-A40 you will see are in color. When I select these items from my list box on the "Schedule" or on the position list box on the sheets "Monday-Sunday" column D4-D29 they do not appear in color. How do I program these to appear in color where the lists boxs are targeted?

Thanks in advance for your help.

**martindwilson** · 09-12-2009, 09:47 AM

you will have to apply the fromatting rules to those cells as well
copy/ paste special formats

**JBC** · 09-12-2009, 10:33 AM

I tried this and it on gives one color the shifts and position list box is color coded with different colors. If I copy paste special all it only shows one color. How do I get it to use the color of the specific item in the list?

Thanks again!!

**martindwilson** · 09-12-2009, 11:27 AM

works for me i copied one that was formatted and pasted it into one that wasnt
otherwise you will have to apply the same rules in the same way as you did the others to those cells