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'

Please Login or Register  to view this content.

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..

Please Login or Register  to view this content.

Many many thanks.