A Arcticwarrio Active Member Joined Dec 6, 2005 Messages 439 Dec 6, 2005 #1 Hello. I need to lock the data of a column without protecting the sheet. the column contains formulas that add other cells. but i need to be able to change colour etc to all other area's of the sheet. is this possible?