ExcelBanter - How to copy formatting in validation cells?

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

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

- - How to copy formatting in validation cells? (https://www.excelbanter.com/excel-worksheet-functions/147464-how-copy-formatting-validation-cells.html)

iamkrisc

How to copy formatting in validation cells?

In MS Excel I have a list of cells which I use for Validation in another
column. I want to be able to format certain cells in this list and when the
cell is validated in the other column have the format stay the same as the
list. How do I do this?

All times are GMT +1. The time now is 05:36 PM.