I am making a spreadsheet to do some calculations for me.
On another worksheet is a list of customers. Some of the customers are
highlighted in blue to indicate that they are currently inactive.

On the new spreadsheet I have cell = the corresponding cells in worksheet 1.
Is there any way to carry over the formatting (highlighted color) as well?
In worksheet 1, the customers are manually Highlighted.
For example: A1 (worksheet 1) is highlighted blue, I want a cell in
worksheet 2 to =A1 and be highlighted in blue.