Excel: copy cell formatting in equation

Solution 1:

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

Solution 2:

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

Solution 3:

Formatting:
You can create a conditional formatting in A2 that refers to A1 (create the exact same rules for conditional formatting in A1 and A2).
I already wrote a little how to yesterday here. Just follow the instructions and make sure you select both cells that should have the conditional formatting.

Value:
Simply put your functions in A2 and A1