Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-26-2013, 11:12 AM
Alaska1 Alaska1 is offline Counting Color in Cells Windows 7 64bit Counting Color in Cells Office 2007
Advanced Beginner
Counting Color in Cells
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default Counting Color in Cells

Is there a way in excel to count the number of color cells.

Example: How many cells are Red?


How many cells are Green?
Reply With Quote
  #2  
Old 07-27-2013, 12:12 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Counting Color in Cells Windows 7 64bit Counting Color in Cells Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Is the color obtained by conditional formatting? If not you'll need VBA I think. Google around it' a well known problem
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 07-27-2013, 04:23 AM
Alaska1 Alaska1 is offline Counting Color in Cells Windows 7 64bit Counting Color in Cells Office 2007
Advanced Beginner
Counting Color in Cells
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default Is there a way in excel to count the number of color cells.

Thank you for your response. The color is not obtained by conditional formatting. It is added to the cells. Try a VBA code to count the color of cells?
Reply With Quote
  #4  
Old 07-27-2013, 09:54 AM
Alaska1 Alaska1 is offline Counting Color in Cells Windows 7 64bit Counting Color in Cells Office 2007
Advanced Beginner
Counting Color in Cells
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

The number will be in conditional formatting. There is any ease way to count without VBA code?
Reply With Quote
  #5  
Old 07-27-2013, 11:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Counting Color in Cells Windows 7 64bit Counting Color in Cells Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet, or is it the one in your other post?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #6  
Old 07-27-2013, 11:32 AM
Alaska1 Alaska1 is offline Counting Color in Cells Windows 7 64bit Counting Color in Cells Office 2007
Advanced Beginner
Counting Color in Cells
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default counting color cells

It is the one in the other post.
Reply With Quote
  #7  
Old 07-28-2013, 11:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Counting Color in Cells Windows 7 64bit Counting Color in Cells Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

To count the red cells ( where value is less then the preceding cell ) try
Code:
=SUMPRODUCT(--($A$1:$G$2>$B$1:$H$2))+SUMPRODUCT(--($A$1:$A$2<$B$1:$B$2))
For the green cells
Code:
=SUMPRODUCT(--($A$1:$G$2>$B$1:$H$2))+SUMPRODUCT(--($A$1:$A$2>$B$1:$B$2))
Adapt ranges to your needs
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #8  
Old 07-28-2013, 04:36 PM
Alaska1 Alaska1 is offline Counting Color in Cells Windows 7 64bit Counting Color in Cells Office 2007
Advanced Beginner
Counting Color in Cells
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default counting color cells

Thank you!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting cells with multiple complex criteria TishyMouse Excel 12 12-06-2012 05:05 AM
Counting Color in Cells various data needs counting apples Excel 2 09-16-2012 04:52 AM
Counting Color in Cells Counting Colors g48dd Excel 2 03-13-2011 09:28 PM
Counting Color in Cells Need cells to autofill with color Silver Rain 007 Excel 1 10-22-2009 08:19 PM
Counting Color in Cells Counting Weeks leroytrolley Excel 1 08-18-2008 11:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft