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   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Counting colored cells

 
   Home -> Office -> Worksheet Functions RSS
Next:  Worksheet Functions: If Function With A Time  
Author Message
Joebeone

External


Since: Aug 06, 2008
Posts: 1



(Msg. 1) Posted: Wed Aug 06, 2008 1:38 pm
Post subject: Counting colored cells Add to elertz
Archived from groups: microsoft>public>excel>worksheet>functions (more info?)

Is there a way to count cells that are a certain color. Like count how many
cells are blue or how many are red
Back to top
Login to vote
Peo Sjoblom

External


Since: Jul 07, 2008
Posts: 398



(Msg. 2) Posted: Wed Aug 06, 2008 2:02 pm
Post subject: Re: Counting colored cells Add to elertz [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

http://www.xldynamic.com/source/xld.ColourCounter.html

--


Regards,


Peo Sjoblom

"Joebeone" <Joebeone DeleteThis @discussions.microsoft.com> wrote in message
news:09BAF779-01F0-4B5C-ABEC-8C0127B792C7@microsoft.com...
> Is there a way to count cells that are a certain color. Like count how
> many
> cells are blue or how many are red
Back to top
Login to vote
Chip Pearson

External


Since: Aug 31, 2003
Posts: 1573



(Msg. 3) Posted: Wed Aug 06, 2008 4:20 pm
Post subject: Re: Counting colored cells Add to elertz [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You need a VBA function to do this. See
http://www.cpearson.com/Excel/colors.aspx for example code.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"Joebeone" <Joebeone.TakeThisOut@discussions.microsoft.com> wrote in message
news:09BAF779-01F0-4B5C-ABEC-8C0127B792C7@microsoft.com...
> Is there a way to count cells that are a certain color. Like count how
> many
> cells are blue or how many are red
Back to top
Login to vote
DS-NTE

External


Since: Jun 28, 2006
Posts: 23



(Msg. 4) Posted: Wed Aug 06, 2008 10:47 pm
Post subject: Re: Counting colored cells Add to elertz [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You will find sth here:

http://www.cpearson.com/excel/mainpage.aspx


"Joebeone" <Joebeone.RemoveThis@discussions.microsoft.com> skrev i melding
news:09BAF779-01F0-4B5C-ABEC-8C0127B792C7@microsoft.com...
> Is there a way to count cells that are a certain color. Like count how
> many
> cells are blue or how many are red
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Worksheet Functions 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
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET