View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Saravana Saravana is offline
external usenet poster
 
Posts: 2
Default For a Cell A3, i use '=A2' ..i want to copy the format of A2 also,

Hi,

I have a cell A3 in which i want to insert both the contents and format of
the cell A2 .. Can somebody plz advise me on how to go about it..

To be specific, A2 contains a number, say 21 and is shaded blue. Exactly i
want the same in A3. (Both the number and color)

Sincerely awaiting a reply..