Hello

I have cell (lets say A1) with a value of 10 and the fill colour is red (i.e the cell is red).

I want cell A2 and many more cells to be exactly like A1 i.e same value and colour.

If I do =A1, cell A2 will only have the numerical value and not the same fill colour as A1.

What can I do?

I want a formula or smthin that will be automatic. Not a simple copy paste i.e. doing it manually.