View Single Post
  #1   Report Post  
Ann Knoff
 
Posts: n/a
Default Totalling numbers that are Conditionally Formatted

Is there any way to total up a column by the colours of a cell?

I have a column that has Green, Yellow, Amber and Red cells and I need to
add up how many of each are there and then calculate the percentage.

Any help would be gratefully received!

Ann