Pull in the cells Format that is found using a Vlookup formula

How do I get the Vlookup formula to pull in the selected cell format to the destination cell?

A formula cannot return a format - you would need to use a macro to do that.

Pete

Thank you, Pete. I was not sure if there was a way. I accomplished the same thing using Conditional Format. Thanks again!