I have a similar problem - to a thread with the same title
http://www.excelforum.com/excel-gene...ted-cells.html
I'm attempting to count cells that have been conditionally format based on the criteria that it matched the value in another cell. i.e. drawn lotto numbers that match my numbers played for particular draw.
I'm looking to count the number of cells that are formatted.
Conditional format applied to my number that match drawn number which have been input on sheet.
=COUNTIF($B3:$AX3,BB3)>0 :: cells are coloured blue applies to :: =$BB$3:$EK$2918
TIA
Bookmarks