Need custom Formula to count only bold cells in a filtered column - using a sumproduct with subtotal
My report uses TSQL to bring data from a database and then uses VBA to create a Excel report. The report has an auto filter across the columns.
The records returned are bolded for the first instance of a name, and the second instance is a light gray.
The Excel cell B4 has a formula that counts the visible rows for the text matching in A4.
Now, I need to only count the bold cells.
Shown is the working formula in the Cell. The working code that puts the formula in the cell, and a small screen shot.
My guess is that some kind of conditional format need to be embedded in the subtotal section. Any suggestions would be appreciated.
Excel cell B4 contains
VBA code counts recordset (intMaxRecordCount) and generates dynamic formula
Bookmarks