Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Counting by colour?

  Asked By: Mehndi    Date: Feb 18    Category: MS Office    Views: 658
  

I have several columns of dates, some in white (hidden) and some in
black. I would like to be able to count the number of dates in black
font. Is this possible?

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Clayton Richardson     Answered On: Feb 18


Put this in a loop statement



If Selection.Interior.ColorIndex = 1 Then

Count = Count + 1

End If


 
Answer #2    Answered By: Adelinda Fischer     Answered On: Feb 18

but where do i enter this statement, in
the cell or some designated area?

 
Answer #3    Answered By: Tamara Nguyen     Answered On: Feb 18

Insert the code in a macro. If you are not sure how to create your own
procedure, record a macro, and then edit it. You will be able to enter
the code there.

 
Didn't find what you were looking for? Find more on Counting by colour? Or get search suggestion and latest updates.




Tagged: