Counting Color in Cells

		Microsoft Office Forums > Microsoft Excel > Excel
Counting Color in Cells

FAQ

Thread Tools

Display Modes

07-28-2013, 11:49 AM

Pecoflyer

Windows 7 64bit Counting Color in Cells

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

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

__________________
Using O365 v2503 - 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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:02 AM.