I have an excel file where I want to set up data validation with dependent lists. I have set up the named ranges. I have data validation set up in the first column. However when I go to apply the dependent list in column 2 only the first cell of the column works properly. I have tried the format painter, fill down, highlighting an entire column before applying the dependent list validation... nothing works. Any idea of what I am doing wrong here?