Counting in Excel spreadsheets

  Newuser3477 21:25 22 Feb 2010
Locked

Is it possible to count the number of cells coloured blue in a column containing only blue colour filled cells and blank ( no fill ) cells. If so please advise me of count formula
Thanks

  fsbb 22:54 22 Feb 2010

Formula for counting blank cells is as follows (in this sample cell range is A1:A10)
=COUNTBLANK(A1:A10)

Colour in a cell is a format and those cells are blank unless an entry, number or text, is inserted.

  VoG II 09:32 23 Feb 2010
  Newuser3477 09:47 23 Feb 2010

Thanks for answers I can now do the counting I need

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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?