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 J
Multiple Selections Drop Down List (used a VBA code) & CountIfs
I used a VBA code to allow me to select multiple items from a drop-down list in a particular column. I have two other columns with other drop-down lists but not allowing for multiple selections. I'm using COUNTIFS to count for certain parameters among the three columns in 3 x 2 columns for each parameter. When I use COUNTIFS, excel doesn't count the parameters in the multiple selection drop-down list. It'll count only if I select one item but once I select more than one, it doesn't count any of the parameters. How can I get excel to count what I want it to count? Thanks.
Drop down list data validation
Thanks for your assistance. I have created some new worksheets with the drop down list target choices and set up the drop down lists on the main worksheet. However, my drop down list choices are decrementing with each line I go down on the main worksheet. If, say, I have 20 choices in one of my drop down worksheets, by the time I get to a cell in the column on the main worksheet containing the link to that list, if I'm on line 21, there are no options displayed in the drop down for that cell. When I take a look at the data validation, I can see that the main worksheet is not referring to the 20 drop down list options as a set feature, but moves down a line in the target worksheet each time I go down a line on the main worksheet. I hope I have explained that clearly. I seem to missing making some correct setting in my data validation, but I can't pick what it is that I'm overlooking.
