Count If a certain cell color meets a certain criteria

[Guest]

I'm trying to count the number of cells that have a certain interior color criteria that all have the contain the same text. Does anyone know how to do this with formulas?

 

[Vasant Nanavati]

Chip Pearson shows you how:

www.cpearson.com/excel/colors.htm

--

Vasant

I'm trying to count the number of cells that have a certain interior color

criteria that all have the contain the same text. Does anyone know how to
do this with formulas?

 

[Guest]

Thanks I found it in the WEB site. Do you happen to know how to change it in to a formula? This formula =COUNTBYCOLOR(A1:A10,3,FALSE) gives me a result of $NAME?

Or can you decipher this

Function CountByColor(InRange As Range, WhatColorIndex As
Integer, Optional OfText As Boolean = False) As Lon

' This function return the number of cells in InRange with
' a background color, or if OfText is True a font color,
' equal to WhatColorIndex

Dim Rng As Rang
Application.Volatile Tru

For Each Rng In InRange.Cell
If OfText = True The
CountByColor = CountByColor - _
(Rng.Font.ColorIndex = WhatColorIndex
Els
CountByColor = CountByColor - _
(Rng.Interior.ColorIndex = WhatColorIndex
End I
Next Rn

End Function

 

[Frank Kabel]

Hi
you have to put the code you found on this website into a standard
module of your workbook. See the following site for getting started
with macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm