VLOOKUP does not work with cell shading that I know of, but I would try a
combination of the vlookup fuction and conditional formatting. Or, you may
be able to just use conditional formatting, depending on the conditions.
Hope this helps!
Chad
"waldersha" wrote:
I would like to use a vlookup function to pull cell shading as part of
the results. Is this possible? We have a database that uses colors to
signify status of accounts and would like this to pull into another
sheet that uses vlookup.
Thanks for any help.
--
waldersha
------------------------------------------------------------------------
waldersha's Profile: http://www.excelforum.com/member.php...o&userid=26460
View this thread: http://www.excelforum.com/showthread...hreadid=397277