Counting coloured cells in Excel

  Newuser3443 10:55 24 Oct 2008
Locked

Does anyone know if there's a built in function in Excel 2003 to count the number of cells in a column that match a particular colour please?

The cells have been coloured manually not using conditional formatting.

TIA

  VoG II 11:30 24 Oct 2008

No there isn't but there is a Used Defined Function click here

  Newuser3443 11:32 24 Oct 2008

Will give that a go. Thanks again as always VoG.

  Newuser3443 11:47 24 Oct 2008

It's worked! you're a star - thanks.

  Picklefactory 11:57 24 Oct 2008

Don't forget to tick as resolved to save others from trying to fix what has been already fixed.
Cheers and glad you're sorted.

  Newuser3443 19:28 24 Oct 2008

Cheers Picklefactory - thought I already had done, but hopefully I've done it right this time.

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

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?