Dashboard in Excel - counting coloured cells?

  cstirrat 15:06 24 Nov 10
Locked

Hi,
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.
C.

  VoG II 15:46 24 Nov 10

If they are manually coloured click here

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

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…