Drop-down list from table w/Data Validation copy format of table too?

[shivers]

Attached my workbook.

I would like the drop-down list I have set on "Characters" sheet (row 3 starting at column B, I just filled right to column N) to copy the font+background color formatting from the "Table" sheet table, is this possible? Thank you for any help.

[Ravisca2003]

Done..

I had to manually create formatting rules based on your sheet format and drgged it to all cells where you need to have dropdown. data valiation alongwith formtting rules were copied. Hope this helps. Not a brilliant approach but my two cents for you. Please recognize if purpose solved.

[davesexcel]

This would go in the worksheet module,

RightClick.jpg

Please Login or Register  to view this content.

[shivers]

Thank you!