Hi Jase,

Not sure exactly what you're asking for, but data validation and cell
formatting are independent features. You can apply cell formatting and data
validation to the same cell, but you can't control cell formatting in any
way using data validation. You also can't control the formatting of a list
displayed by the data validation feature.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Jase" wrote in message
...
Hi Guys

I have code that creates a basic data validation, and
that part works. However I have discovered that I am
unable to bring the formatting of my cells into the
validations does anyone know of a way to either bring in
the format of the cells or of another type of object that
I can use to create a list with formatting in it (and
preferably assign that list to a cell).

Thanks heaps
Jase