Copying Conditional Formating to another worksheet

A

Al Prior

I am using conditional formating to designate a player in a league and their
opponent. Since there are several leagues, I wanted to be able to copy the
conditional formating from one sheet to another.
When I copy the worksheet, I go to the new sheet, right click on the upper
left worksheet button, selecting the entire sheet, select paste special, then
select All. Everything works perfectly, accept the conditional formats.
It appears to add more conditional formats from the copy / paste procedure.
I have selected the new worksheet, selected conditional formating, then
cleared existing conditional formats for the entire sheet.
Done this many times?
Is this a known problem with MS Excel, or am I doing something incorrectly?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top