Use Copy / Paste. It will copy both the cell's contents and its format.
--
Gary''s Student


"careyc" wrote:


I'm trying to duplicate cells exactly from one sheet to the next. I'm
using IF commands to get the data entered in a cell in one sheet to
show up in the next, but is there anyway to also mirror the format,
i.e. bolded text, highlights, etc.?

Thanks in advance!


--
careyc
------------------------------------------------------------------------
careyc's Profile: http://www.excelforum.com/member.php...o&userid=26064
View this thread: http://www.excelforum.com/showthread...hreadid=476778