I don't think this is possible, but maybe someone has tackled it. I have a
cell that shows the result of its vlookup formula. I was hoping, with that
cell selected, that some option inside Edit . . . Go to . . . Special would
"jump" to the cell where the lookup was getting its data. I was thinking, if
this was possible, I could write a macro that uses that function to "go back"
to the source cell, copy the formatting (using the format painter), then
return and apply the formatting to the vlookup cell. But I know every time
someone asks if it is possible to "bring forward" the formatting from a
lookup cell, the answer is no.