Is there a way to reference both another cell's value and formatting? I have 2 sheets, one with book numbers and their current status and the other with orders. I have the orders sheet perform a vlookup on the book number on the book number page. While this gives me the current status of the book, I also want the format of the status cell(bold, underline, bg color, etc) to show up on the corresponding cell on the orders sheet. Is this even possible using only worksheet functions? I can easily do this with VBA, but I am trying to get this done without resorting to that. Any help would be appreciated.