PC Review


Reply
Thread Tools Rate Thread

2010 Format Questions Please

 
 
Bob Newman
Guest
Posts: n/a
 
      9th Oct 2011
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
 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      9th Oct 2011
On Oct 9, 8:48*am, Bob Newman <newmaga...@gmail.com> wrote:
> 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


I answered this for you in another forum
 
Reply With Quote
 
Bob Newman
Guest
Posts: n/a
 
      9th Oct 2011
On Oct 9, 10:26*am, Don Guillett <dguille...@gmail.com> wrote:
> On Oct 9, 8:48*am, Bob Newman <newmaga...@gmail.com> wrote:
>
> > 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

>
> I answered this for you in another forum


That answer doesn't help much. Give me a hint please.

Bob
 
Reply With Quote
 
Don Guillett
Guest
Posts: n/a
 
      9th Oct 2011
On Oct 9, 9:43*am, Bob Newman <newmaga...@gmail.com> wrote:
> On Oct 9, 10:26*am, Don Guillett <dguille...@gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> > On Oct 9, 8:48*am, Bob Newman <newmaga...@gmail.com> wrote:

>
> > > 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

>
> > I answered this for you in another forum

>
> That answer doesn't help much. Give me a hint please.
>
> Bob


Go back to the other forum to see my answer for xl2010
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:53 PM.