Sharpie123
05-28-2005, 07:31 AM
I am a new member and hope that this is the correct forum for this question. If not I apologize for the mistake. Here is what I am trying to do:
I have created a spreadsheet that contains a dropdown list with 6 choices. The selections for the dropdown are on sheet2 of the workbook. I have the dropdown functioning in multiple cells on sheet1. I want to add colors to the dropdown list so that when a particular entry is selected that entry is displayed in the cell and the cell fill color changes to reflect whichever color I assign to that entry. For Example: If the selections were Yes and No I would like to be able to set it so that if the selection was Yes then the word Yes would display in the cell and the cell fill color would change to Green. If the answer was No then the cell would display the word No and the fill color of the cell would change to Red
Hope someone can help with this and thank you
I have created a spreadsheet that contains a dropdown list with 6 choices. The selections for the dropdown are on sheet2 of the workbook. I have the dropdown functioning in multiple cells on sheet1. I want to add colors to the dropdown list so that when a particular entry is selected that entry is displayed in the cell and the cell fill color changes to reflect whichever color I assign to that entry. For Example: If the selections were Yes and No I would like to be able to set it so that if the selection was Yes then the word Yes would display in the cell and the cell fill color would change to Green. If the answer was No then the cell would display the word No and the fill color of the cell would change to Red
Hope someone can help with this and thank you