Forum Discussion
Copy content and format of a cell in a formula.
So cell A1 says: Alex if I go to A2 and put in the formula "=A1" This will give me: Alex However I want to keep the color red and the background color if there is one as well as "bold" or u...
No, formulas don't work that way.
You can use the Camera Tool to create a "live" picture of a cell (or range). It will automatically be updated when you change the value or formatting of the source cell, but it will be just a picture: you won't be able to use it in formulas.