IMO, on the contrary,
its much easier just to count cells with letters in them

Example:
=COUNTIF(B2:D4,"L")
will return the count of cells within B2:D4
containing the letter "L" (case-irrespective)

=COUNTIF(B2:D4,"x")
Ditto for letter "x" (case-irrespective)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"JJ" wrote:
I am trying to count colored cells that have a letter in them. I have it set
up already that when I type in a letter a colored background shows up in the
cell. I have tried many different functions to count the cells but they only
work if the cell doens't have a letter in it. So it only works when the cell
only has color in it.