Formula based on the colour of the cell (counting)

Something like this?

http://www.extendoffice.com/document...-by-color.html

Hi

I did my suggestion without to open your example sheet.

Opening it is believe that a simple countif will do the job.

Formula:

=COUNTIF(H3:H40,"First cut received")

Also i used A cONDITIONAL fORMATTING in column H do don't need to fill with color manually.

Originally Posted by renix

Thanks Fotis, that is great.
I will also be changing colours in Columns E, F, G to green and red. I would want to count how many greens I have.
How would I do that?

Count according the condittion that you'll have for been green. Which will be this?

Ok. I ask you again. Is there a condition on which you fill with color these columns?

In this case we go back to my suggestion in post#2

Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean)
Dim rCell As Range
Dim lCol As Long
Dim vResult
lCol = rColor.Interior.ColorIndex
If SUM = True Then
For Each rCell In rRange
If rCell.Interior.ColorIndex = lCol Then
vResult = WorksheetFunction.SUM(rCell, vResult)
End If
Next rCell
Else
For Each rCell In rRange
If rCell.Interior.ColorIndex = lCol Then
vResult = 1 + vResult
End If
Next rCell
End If
ColorFunction = vResult
End Function

=colorfunction($H42;E$3:E$40;FALSE)

This is a UDF function.

Click on the result cell. Take your cursor in formula bar. Press Enter. Done.

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.