Copy Data from one sheet of excel with cell colour

How to Copy Data from one sheet of an excel with its all cell colors and paste it to another sheet?

Best approach will be using Macros for Flawless Execution

If you know the colored cells you can use read range for the colored cells and get the needed data in the form of datatable and send to new excel.

Let us know if this helps.
Pavna H