thank you, that did work and I can not change the conditional formatting. However someone can still cut and paste and move the conditional formatting. Is there away to remove the cut/copy function for the unlocked cells so that they have to manually enter a number each time?