Editable locked cells

I'm having trouble finding information on how to lock cell size, width, and colour while allowing users to still edit cells in Excel 2003.

Basically, we use an excel spreadsheet to keep track of advertising sales at the small newspaper I work at. We have a pre-formatted worksheet for each week that is colour coded to make it easy to print and read. The problem is that three people access it during a given week to enter the various info related to their job. By the time it gets to me at the end of the week, a plethora of cut-and pasting (that changes the colour) and changing of cell sizes makes the spreadsheet difficult to read and time consuming to re-format. All the cells start out the right size and colour, is there a way to lock the spreadsheet so that this can't be changed while still allowing users to enter their info as text?

Any help would be appreciated.

Hi,

I hope "allow users to edit ranges" option can help you. You can go this option from data menu, protection.

Within allowed ranges, other people can edit the value, but not formats.

Try it!

Hoping, it can solve your problem,

YKNet

I gave that a try but it still won't lock the format completely, as the formats I need to remain the same are all within the range. Thanks for the suggestion though !