Hi...I'm using excel 2010 and have data that is conditionally formatted to change color based on the entered data. I want to be able to count the # of colored cells automatically and have that value populate in the cell I want it to.
Thank you for your time into this!
What is the rule that applies the CF?
You should be able to write a formula using the logic of the CF rule to get the count.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Here are the two conditions...first one is colored green and the second one is colored red
=AND(A2>=(A1-"0:10"),A2<=(A1+"0:05"))
=OR(A2<(A1-"0:10"),A2>(A1+"0:05"))
Hello DJFISH614,
The information in this article (steps 1-7) will help you quickly accomplish your goal :
https://support.microsoft.com/en-us/kb/2815384
OK, you'll have to put those in context.Originally Posted by DJFISH614
What's in A2?
What's in A1?
What cell is the formatting applied to? What cells do you want to count?
In this instance it's time. A1 is the Scheduled time and A2 is the actual time...This is actually being changed to A1 and B1 to read side by side. Where the B Column (actual) has the conditions set on it. below the data is where I want the count to go.
I think we're going to need to see a sample file.
Can you post a SMALL sample file and show us what result you expect?
A SMALL file will have about 20 rows worth of data.
I think I uploaded the attachment correctly.
I think this does what you want...
Data Range
This formula entered in D8:
=SUMPRODUCT(--(D3:D7>=C3:C7-TIME(0,10,0)),--(D3:D7<=C3:C7+TIME(0,5,0)))
This formula entered in D9:
=COUNT(D3:D7)-D8
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks