2010 Format Questions Please

B

Bob Newman

Excel 2010 - I am using a sheet created by someone else and would like
to delete the following 2 formats that I am unfamiliar with:
1. In the upper left corner of many cells are little green "wedgies",
how do I
get rid of them?
NOTE: I unchecked OPTIONS/FORMULAS "formulas referring to empty
cells" and about 1/2 of the wedgies disappeared.
2. Some of the cells have a yellow background color even though I have
chosen
none for the fill option. I believe this has something to do with a
conditional
formatting. How do I get rid of the background color?

Thanks in advance... Bob
 
D

Don Guillett

Excel 2010 - I am using a sheet created by someone else and would like
to delete the following 2 formats that I am unfamiliar with:
1. In the upper left corner of many cells are little green "wedgies",
how do I
get rid of them?
  NOTE: I unchecked OPTIONS/FORMULAS "formulas referring to empty
cells" and about 1/2 of the wedgies disappeared.
2. Some of the cells have a yellow background color even though I have
chosen
none for the fill option. I believe this has something to do with a
conditional
formatting. How do I get rid of the background color?

Thanks in advance... Bob
Click to expand...

I answered this for you in another forum
 

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

Editing conditional formats (Excel 2010) 15
SUMPRODUCT and SUMIFS combined with Sumifbycolor (VBA code) 1
2010 Format question please 0
Copy and Link Issues 2010 1
Conditional Formatting Based On Formula Values 2
NAME error in excel 2010 0
CF on Consecutive cells 1
Cumulative formula for word table 0

Top