Excel: copy cell formatting in equation

There doesn't exist any standard Excel function that does what you are asking. You need a user defined function to be built via VBA

I am not sure entirely what you are asking for but if what you are trying to do is copy a cell with a formula that references a specific cell through multiple cells that will still reference back back to the one cell (I.E. A2 + B2 = C2, copied to next row down to be A3 + B2 + C3) you will need to include $ before the cells you are wanting a fixed reference on in the formula. Is this the right direction or am i mis reading your question? Try this link for more help http://office.microsoft.com/en-us/excel/HP101023421033.aspx