Not with a formula


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rickcstahl" wrote in message
...
I am using VLOOKUP to retrieve values from several different worksheets. I
also wish to retreive the cell's format (color). There are many different
colors on the worsheets based on many complex criteria. Is there anyway
the
individual formats of the cells retrieved can also be returned with the
values ?

Thanks,
Rick