ExcelBanter - how do I copy format (eg colour of cells) in a drop down list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I copy format (eg colour of cells) in a drop down list (https://www.excelbanter.com/excel-worksheet-functions/250597-re-how-do-i-copy-format-eg-colour-cells-drop-down-list.html)

Gord Dibben

how do I copy format (eg colour of cells) in a drop down list

If using a Data Validation dropdown list..............you cannot do this.

Gord Dibben MS Excel MVP

On Tue, 8 Dec 2009 20:06:01 -0800, SamR
wrote:

All times are GMT +1. The time now is 03:45 AM.