Sheet Protection On

[JMay]

It seems that if a sheet has been "protected" I can not
format (fill with color) even a cell that is not protected.

What is the solution for this?

I need to be able to format unprotected cells, rows and also columns. But How?

TIA,

 

[Bob Greenblatt]

It seems that if a sheet has been "protected" I can not
format (fill with color) even a cell that is not protected.

What is the solution for this?

There is none. That's what protection is for.

I need to be able to format unprotected cells, rows and also columns. But
How?

There are just some things you can't do with the sheet protected, even if a
cell happens to be unprotected. To change cell colors you must first
unprotect the sheet. You can only change unprotected cell values when a
sheet is protected.

 

[JE McGimpsey]

It seems that if a sheet has been "protected" I can not
format (fill with color) even a cell that is not protected.

What is the solution for this?

I need to be able to format unprotected cells, rows and also columns. But
How?

The only way I know of to do this is to use VBA event macros to replace
sheet protection. Doing so can be either very simple or very
complicated, depending on what properties you want to protect, and may
require running OnTime macros to audit the sheet for changes.