Hi,

I am attempting to make a production schedule in excel with the use of conditional formatting.

The issue arises with the fact that I need to be able to re-order the jobs at anytime and need the conditional formatting to remain fixed.

I have built and rebuilt the book many times changing the way I protect it and it never fails to mess up once I close the book and reopen it.

I have all the cells formatted to 'Locked' and protect the sheet to the point that they are not able to even select a cell.

The schedule is set up to hold up to 98 jobs at one time. The most common origin of the problem comes from just above ov below the last job scheduled.

Is there any way to absolutely lock the formatting so it will not move in the schedule sheet when I rearrange the job order in a separate sheet?

Thank you
Jessica