formula for counting highlighted cells (or lines)
Posted by Dana A on October 09, 2001 6:51 AM
I'm needing a formula to count how many lines (not necessarily cells) are highlighted within my worksheet.
For example: I keep a total of how many online queries are sent to me and how many are sent in by snail-mail. My online submissions are the highlighted lines and they change as more facilities go online. I need a running total of how many should be submitting online. So I need a formula that can count highlighted lines (the highlighted lines/cells don't always have data in them).