What function to use in Excel to display not only the data, but also the colors of the cells?

Question

excel

How can you execute a function in Excel, but so that the formulas work not only on the data, but also on the colors of the cells and font?
A very simple example using "=" :
1. there is a cell A1 with the number 1 and a red fill or font.
2. put in any other cell =A1
3. the number 1 is copied, but not the colors and font
4. is it possible to copy the colors somehow?

Answer 1

You can't do it with the usual Excel tools. Or vba, or you might just use conditional formatting.

Answer 2

so conditional formatting isn't it?

Answer 3

Plex has a cell color formula.
www.planetaexcel.ru