View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alicia
 
Posts: n/a
Default Is there a way to count the number of highlighted cells in a col?

I have a column with about 8000 cells, all with different words in each cell.
Some cells are highlighted, some are not. I would like to know how many
cells are highlighted. Is there a way to count them or sort by highlighted
versus non-highlighted?