Green cell corners

  • Thread starter Thread starter Hot ICQ
  • Start date Start date
H

Hot ICQ

I have a spreadsheet with a bunch of cells that have green corners.
I would like to get rid of the green corners now if someone can tell
me how?

A few weeks ago if I recall correctly I formatted these cells and
protected the worksheet.
When the worksheet was protected, the green corners were removed.
Now that I have unprotected the worksheet, the green corners have
reappeared.

Here's what I have in some of the cells:
E2: =d2-c2
F2: =b2*c2
J2: =e2/c2*100

When I select the cells and look at formatting I don't see anything
special.
I also don't see conditional formatting.

TIA
 
Excel 2003:
Tools/options/Error checking/deselect "Enable Background Error Checking"
Excel 2007:
Office Button/Excel Options/Formulas section, deselect same thing (about 2/3
the way down)

Bob Umlas
Excel MVP
 
Excel 2003:
Tools/options/Error checking/deselect "Enable Background Error Checking"
Excel 2007:
Office Button/Excel Options/Formulas section, deselect same thing (about 2/3
the way down)

Bob Umlas
Excel MVP


Thanks very much Bob, that did the trick! :)
 

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

Subtotals 5
cell format update problem 3
can't change cell format 3
2010 Format Questions Please 3
Error Triangle in Corner of Cell 2
Excel VBA 1
Counting Cell Background Colours 18
Conditional Formatting 4

Back
Top