Thanks for your reply Kimberly.



The method you described certainly can protect the formatting, however it does not allow for any data input into those cells.

Excel 2007 has one option under the protect sheet icon and that brings up the protect sheet dialogue box. This does not offer any options for protection of formatting.
Under the protect workbook icon there is the option to protect structure and windows, neither of which will protect the formatting in cell and allow for data input.

I would like to have the worksheet setup so that individuals who will be entering data cannot accidentally change the formatting in a cell. How does one setup the sheet to allow for formatting consistency and data entry?

I have used your method for protecting my formulas. Work great!

Thanks

DD