I have a xls file that will not let me do any cell formatting to some cells.
I can use the format painter to force changes. The sheet is not protected.
I have the same problem whether it is marked locked or not.

When I select Format | Format Cells.. , right click the cell and select
"Format Cells..", CTRL+1, nothing happens. I can use the Alignment buttons
but will never get the Format Cells Dialog Box.

Other cells on the same sheet work just fine? I'm using 2007