View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default retaining formats when referring to cells

While you can't link formats, you can take the cells in A, copy them, and
paste/special/formats into B
--
Gary''s Student - gsnu200739


"Michaeld" wrote:

I have conditional formats in cells in worksheet A. When I refer to those
cells from WorksheetB, I want to reflect the formats they have in Worksheet
A, in WorksheetB
Any thoughts