Hi
I'm sure there is something simple I've overlooked but I cannot figure out how to get a named list to copy the cell formatting as well when using data validation
The list I have has coloured cells and text but when they are selected on another worksheet they have the standard formatting
Can anyone help?
Cheers
Dan
Bookmarks