Functions within Excel can do nothing about formatting, but you can
use VBA to get colours.

Bob Phillips gives details of a User-defined function he

http://www.xldynamic.com/source/xld.ColourCounter.html

which can return the colour of a cell. Perhaps you can incorporate
this into your workbook.

Hope this helps.

Pete

On Jan 9, 5:28*pm, Richard wrote:
Is there another methos?



"Pete_UK" wrote:
No, not using VLOOKUP.

Pete

On Jan 9, 4:58 pm, Richard wrote:
Hi,

Is it possible to look up not only the contents of a cell, but also the cell
color using a vlookup?

Thanks,- Hide quoted text -

- Show quoted text -