Cell shading locked?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to edit a previously saved spreadsheet. Many of the cells are
colored, and I would like to eliminate the shading. However, whenever I
select a shaded cell and try to remove the shading by choosing "No Fill,"
nothing happens. I cannot change the color either. If the cell is already
white, I can add shading to those. but the already shaded cells seem to be
"locked." Any advice to getting around this besides retyping the file? Thanks!
 
they are most likely conditionally formatted,

try selecting the cells all the ones affected then Format--> conditional
formatting and press the delete button, tick conditions 1 2 & 3

see if that does it

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: cell shading (not conditional formatting) 1
Can you shade one cell 2 different colors? 1
cell shading 1
shaded cell sumation 2
Is there a non-printing shading? 1
Auto-Format Cell Shading 2
Drop Down Shading 3
How do I use different colours in drop down menus in Excel 2003? 4

Back
Top