Conditional format Order

P

Porky79

Hi Guys,

I have a MASTER worksheet that I copy to create a new sheet before
adding data for an individual. I have the MASTER sheet set up with all
the conditional formats necessary to automate the work sheet when data
is entered. I am using excel 2007 so have set the formats in teh order
I want them to be applied.

However, when the sheet is copied, the first conditional format rule
for some reason drops to being the last format rule. This therefore
changes the conditional format operation on any copied worksheet. Does
anyone know why the order would change & if there is anyway to 'lock'
the order so that it remains unchanged when teh worksheet is copied?

Thanks in advance

Paul
 

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