WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Unchanging Cell Color

 
   Home -> Office -> General Discussions RSS
Next:  Sorting by format - is it possible?  
Author Message
Lavanya Pandian

External


Since: Sep 12, 2007
Posts: 13



(Msg. 1) Posted: Fri Nov 06, 2009 6:28 am
Post subject: Unchanging Cell Color
Archived from groups: microsoft>public>excel>misc (more info?)

I have few cells in a worksheet which is of gray color. I am not able to
change or remove the color from these cells. What could be the reason, and
how can i change it?
Back to top
Login to vote
Gord Dibben

External


Since: Feb 23, 2004
Posts: 8519



(Msg. 2) Posted: Fri Nov 06, 2009 7:46 am
Post subject: Re: Unchanging Cell Color [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Perhaps you have Conditional Formatting on those cells?

F5>Special>Conditional Formats>OK

Do those gray cells get selected?

If so, remove the CF if you choose or revise the rules.


Gord Dibben MS Excel MVP

On Fri, 6 Nov 2009 06:28:01 -0800, Lavanya Pandian
<LavanyaPandian.DeleteThis@discussions.microsoft.com> wrote:

>I have few cells in a worksheet which is of gray color. I am not able to
>change or remove the color from these cells. What could be the reason, and
>how can i change it?
Back to top
Login to vote
Don Guillett

External


Since: Jan 04, 2006
Posts: 2837



(Msg. 3) Posted: Fri Nov 06, 2009 8:41 am
Post subject: Re: Unchanging Cell Color [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Perhaps the columns or rows are HIDDEN

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1.TakeThisOut@austin.rr.com
"Lavanya Pandian" <LavanyaPandian.TakeThisOut@discussions.microsoft.com> wrote in
message news:DDF001F8-2762-4D11-AFFB-4329E2B10E54@microsoft.com...
>I have few cells in a worksheet which is of gray color. I am not able to
> change or remove the color from these cells. What could be the reason, and
> how can i change it?
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> General Discussions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET |
  • IT Support