vlookup color problem

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

hi, when i do a vlookup of a table in a different
worksheet the cell returning the data has a yellow
backround color which is not brought back with the data
in the cell. Does anyone know how i can bring back the
color of the cell along with the data???

Thanks for any help. bob
 
You can't do it with a worksheet function.

You'd have to use some kind of macro.

(or maybe you could use Format|conditional formatting if the options are small)
 
Back
Top