Home » Questions » Computers [ Ask a new question ]

Excel: copy cell formatting in equation

Excel: copy cell formatting in equation

If I make an equation:

Asked by: Guest | Views: 149
Total answers/comments: 2
Guest [Entry]

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
Guest [Entry]

"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"