I have an Excel spreadsheet and I'm trying to count rows in a column based on a style applied to some cells in the column. Is there a simple way to do this?
No, not really. You could use Visual Basic to access cell formatting properties but most inbuilt functions that you would type into a cell focus on the cell contents, not the formatting.
If your styles have different shading colours then you can use the following method.
Step 1: Convert your range to a list and then adding a total row showing COUNT
Step 2: Apply a colour filter (should work on Excel 2007 and later):
Done: The COUNT total will show the filtered number of rows.