Indirect Data Validation list only showing partialy

[Jamie Wagler]

I have created an indirect data validation of colour based on the style chosen. When I select style 1 it's entire colour list is returned but when I select style 2 only 2 of 6 colourse are showing, almost as if the rest of the list is in a white font.

I have checked font colour, data validation, and the area of the named lists all of which seem fine.

Any ideas are welcome.

 

[vletm]

You wrote: Any ideas are welcome.>>> One Idea >>>
Upload a Sample File to get a quicker response