How to Count Highlighted Rows that contain an X ?

Hi All,

To find the best product for my customers I need to count the rows that I have highlighted by filling with a colour AND that contain an 'X' in the cell. Giving a total at the bottom of the row for each highlighted and 'X' cell. I cannot find any easy way of doing this and I am sure I will need to run a VBA script but cant quite get my head around how to do this. Perhaps there is an easier way to do this entirely! I'm open to all suggestions.

I have attached a picture of what it currently looks like.

CountHighlightedXRows.jpg

Many thanks

Sean

Ok i have the following code to count the highlighted cells (thanks to an earlier post today) now i need to add AND contains 'X'

Function Count_Highlights(rng As Range)
Dim CCell As Range, x As Long
x = 0
For Each CCell In rng.Cells
   If CCell.Interior.Color <> 16777215 And CCell.Interior.Color <> xlNone Then x = x + 1
Next CCell
Count_Highlights = x
End Function

Thanks Sixthsense, but i have two requirements: count cells that are highlighted AND contain x

Thank you very much!!
This is the final code that worked for me..

Function Count_Highlights(rng As Range)
Dim CCell As Range, x As Long
x = 0
For Each CCell In rng.Cells
   If CCell.Interior.Color <> 16777215 And CCell.Interior.Color <> xlNone And CCell.Value = "x" Then x = x + 1
Next CCell
Count_Highlights = x
End Function

Many many thanks.