View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike K[_2_] Mike K[_2_] is offline
external usenet poster
 
Posts: 2
Default how to count number of highlighted cells in column

Within an existing worksheet I have a column of data containing cells that
are either highlighted in yellow (manually highlighted) or not highlighted in
yellow. I need to sum how many cells are highlighted in yellow and how many
cells are not highlighted in yellow. I'm running MS Office Excel 2003 SP2.