In the Mac version of Excel 2016, the colors of the cells are not copied, only the data in them. How to solve it?

Question

macOS

On one sheet, I marked repetitions with color and in the same form this column should be transferred to another sheet, but Excel (Office 2016 for Mac) stubbornly does not copy the colors of the cells from anywhere, not from Google spreadsheets, nor from itself, nor from Numbers. What's the matter?
No kind of pasting helps, you have to copy to Numbers-> export to Excel format-> open Excel.