vlookup color problem

[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

 

[Dave Peterson]

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)