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

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017