View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Brad Vogt Brad Vogt is offline
external usenet poster
 
Posts: 37
Default Counting highlighted cells

What caused these cells to be highlighted? Is there a conditional format
involved? I don't think that a formula can refer to formatting from cells.

"Kassie" wrote:

If I want to count how many highlighted cells there are in a row or column is
there a formula that will do that for me - there will be no numbers in these
cells just highlighted. I would want each highlighted cell to count as 1.