I have a workbook with several worksheets. On one sheet there are 2 columns of text (Lname & Fname).
All of the cells are conditionally formatted with either of 3 colors.
There is code in a macro that copies and pastes those columns to another sheet.
Problem is that the colors change when pasted. It's like the 2nd sheet contains formatting that cannot be overwritten. They need to copy and paste as original.
I tried clearing formats prior to copying but no better.
Called Microsoft support but they found no problem with Excel and suggested this site for support.
