Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

If I make an equation:

' on cell A2
=A1

Is there a way to make A2 have the exact same formatting as A1 and not just the value?

EDIT:

i.e. I want a FORMULA that copies both the value and the format/including conditional formatting of the original/source cell

share|improve this question
1  
I think what you're saying is that you want a formula which will calculate a value based on a source cell and also set the formatting of the destination cell based on the formatting of the source cell. Your use of the word "copy" is confusing the issue, since that usually refers to a copy/paste operation. I also don't think you can do what you want because formulas are designed to affect the value of a cell, not its format. The best you can do is apply the same conditional formats to the destination cell that are applied to the source. –  davidcl Jan 22 '10 at 2:17

5 Answers 5

up vote 4 down vote accepted

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

share|improve this answer

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

share|improve this answer
    
This is what I was after, thanks! –  Hainesy Feb 12 '13 at 10:22

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

share|improve this answer

This may not be what you are after, but possibly the camera tool could be useful as a way to return content and formatting, if you are trying to just visually monitor a cell.

share|improve this answer

You need to use the Format Painter tool to copy the conditional formatting.

share|improve this answer
    
I was hoping for a formula –  dassouki Jan 21 '10 at 15:56
    
@dassouki - I don't get it. How can you "formulate" a copy/paste operation ? Could you at least tell us what you need something like that for; it will help us understand the problemy you're having ... –  ldigas Jan 21 '10 at 17:18
    
This is really a comment, not an answer to the question. Please use "add comment" to leave feedback for the author. –  Diogo Aug 9 '12 at 0:59

protected by Sathya Jun 18 at 5:20

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.