In Excel if I use an '=' sign to get the data of another cell, How can I get the same colour?

Question

In Excel if I use an '=' sign to get the data of another cell, How can I get the same colour if the content is of different colour? Format painter only copies the font and style. Not the colour.

Answer 1

Use the "fill". So highlight the cell then use the brush to fill in the color that you want. It should work!