Cell Validation - Drop Down Lists and Text Formatting
Hi, I have a form in Excel that has a couple of drop down list options. I have my lists saved on a separate tab and i would like the options within one of the lists to repeat the specific text/cell formatting i have in place (each option has a different colour of text and cell fill applied, with mixed font sizes within the same cell). Is there a away o can do this without also adding conditional formatting to the cell that contains the drop down? CF doesn't quite give the result i am looking for as it doesn't mirror the mixed font sizing i have in place for the actual list. Would appreciate any help you can offer with this. Thank you JDrop Down List - Linking Corresponding Data in Separate Columns Based on Drop Down Selection
Hey there! I'm looking for a clear cut way to do something which seems like it should be simple. I have two columns that I want to correspond with one another. What I'm looking to do is when someone selects an option "Status" from the drop-down list in Column D the adjacent cell in column E populates with a corresponding percentage value. Ex. --> Cell 'D6' / "Sales Status" Drop Down Selection = Verbal Commitment ::: Needing Cell 'E6' to auto-populate once selected with the corresponding percentage "100%" I've built a drop down list for each column in a data worksheet. Am I doing this correctly? I've attached a screenshot of the columns I need populated as well as my lists in case that helps. Thanks!
