Cell Formatting Problem
 

I am trying to change the formatting in a cell, but when I try clicking on
Formatcell, nothing happens. There's no protection or conditional
formatting on the worksheet, and I am able to format other cells in the
worksheet. Any idea of why I can't change a formatting of some cells but not
others? I don't get any error messages.
Thanks

Cell Formatting Problem
 

Is your sheet or workbook protected? If so, unprotect...
Tools - Protection...
Are you editing the cell when you attempt to format it? If so, hit Esc to
get out of editing mode.

"Darlene" wrote:

I am trying to change the formatting in a cell, but when I try clicking on
Formatcell, nothing happens. There's no protection or conditional
formatting on the worksheet, and I am able to format other cells in the
worksheet. Any idea of why I can't change a formatting of some cells but not
others? I don't get any error messages.
Thanks

Cell Formatting Problem
 

The worksheet is not protected and I am not editing while formatting it.

"Sean Timmons" wrote:

Is your sheet or workbook protected? If so, unprotect...
Tools - Protection...
Are you editing the cell when you attempt to format it? If so, hit Esc to
get out of editing mode.

"Darlene" wrote:

I am trying to change the formatting in a cell, but when I try clicking on
Formatcell, nothing happens. There's no protection or conditional
formatting on the worksheet, and I am able to format other cells in the
worksheet. Any idea of why I can't change a formatting of some cells but not
others? I don't get any error messages.
Thanks

Cell Formatting Problem
 

Have you got any conditional formatting on that cell?

Click on the cell & check conditional formatting under the format menu
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Darlene" wrote:

I am trying to change the formatting in a cell, but when I try clicking on
Formatcell, nothing happens. There's no protection or conditional
formatting on the worksheet, and I am able to format other cells in the
worksheet. Any idea of why I can't change a formatting of some cells but not
others? I don't get any error messages.
Thanks

Cell Formatting Problem
 

There is no conditional formatting on that cell.

"john the confused" wrote:

Have you got any conditional formatting on that cell?

Click on the cell & check conditional formatting under the format menu
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Darlene" wrote:

I am trying to change the formatting in a cell, but when I try clicking on
Formatcell, nothing happens. There's no protection or conditional
formatting on the worksheet, and I am able to format other cells in the
worksheet. Any idea of why I can't change a formatting of some cells but not
others? I don't get any error messages.
Thanks

Cell Formatting Problem
 

what formatting are you trying to change, what is in the cell now and is it
connected to any other cells?
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Darlene" wrote:

There is no conditional formatting on that cell.

"john the confused" wrote:

Have you got any conditional formatting on that cell?

Click on the cell & check conditional formatting under the format menu
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Darlene" wrote:

I am trying to change the formatting in a cell, but when I try clicking on
Formatcell, nothing happens. There's no protection or conditional
formatting on the worksheet, and I am able to format other cells in the
worksheet. Any idea of why I can't change a formatting of some cells but not
others? I don't get any error messages.
Thanks