Help- Important plz!. How to copy value+colour of a cell

[Naja]

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.

[ChemistB]

Formulas cannot do colors unless you do them through conditional formatting. Do you know how to use conditional formatting? (it's on home tab> Conditional formatting)
You could select the rest column and
Conditional Formatting> New Rule>Use Formula
=A1=$A$2
format as blue or whatever is in A2. It won't change automatically if you change the color in A2