Formatting Question. Is there a way (besides cut and paste), where I can reference a cell location from another sheet (same WB) and the new cell, with the referenced cell will inherit all of the formatting or characteristics of the referenced cell? That is to say, if I have a cell, let's say B10 in Sheet 2 that has a yellow background, 14 pt. font, Bold and underlined, with "comments", and I reference it into A10 on Sheet 1 (i.e. =Sheet2!B10), can I get it to show up with the same formatting and comments?
Hopefully the answer is "yes"........... ;-)