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