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: 702

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?



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.