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

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?