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