View Single Post
  #5   Report Post  
Chad
 
Posts: n/a
Default

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