Green cell corners

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
 
B

Bob Umlas

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
 
H

Hot ICQ

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

Top