View Single Post
  #1   Report Post  
amvena
 
Posts: n/a
Default Counting coloured cells

I have a list of percentages that are conditionally formatted and I want to
be able to count how many cells are each different colour. I don't think you
can do this with count if as it only looks for numbers or text and not
formatting but essentially I want to count the number of cells in a range
which are red/gold or green.