Dashboard in Excel - counting coloured cells?

  cstirrat 15:06 24 Nov 2010

Does anyone know how to set up a formula in an Excel summary sheet that will count the number of cells that are, e,g, green, as opposed to the content within them?
I want to create a summary dashboard for a number of tabs within a spreadsheet or across different spreadsheets.
Help would be most appreciated.

  VoG II 15:46 24 Nov 2010

If they are manually coloured click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?