Hi,
I have a spreadsheet that will be used by other people and I have locked all the cells which contain formulae and conditional formatting so that no one can break my sheet. However, there are some columns which the user will free type into and they would like to be able to change the colour of the cells to their own preferences. These cells are not conditionally formatted.
The problem I have is that when I protect the sheet if I allow formatting of cells so that they can do this, they also have access to my conditional formatting rules which I'm not comfortable with. Is there a way I can permit them to change the colour of the unlocked cells without allowing them access to my conditional formatted ones please?
Thank You
I have a spreadsheet that will be used by other people and I have locked all the cells which contain formulae and conditional formatting so that no one can break my sheet. However, there are some columns which the user will free type into and they would like to be able to change the colour of the cells to their own preferences. These cells are not conditionally formatted.
The problem I have is that when I protect the sheet if I allow formatting of cells so that they can do this, they also have access to my conditional formatting rules which I'm not comfortable with. Is there a way I can permit them to change the colour of the unlocked cells without allowing them access to my conditional formatted ones please?
Thank You
