I have a sheet protected for contents only. I need this so I can hide
some rows and columns. It is also preventing me from changing fill
color.

Is there a way to protect hidden rows and also change fill color? ...
excel97