Discussion Locked

Excel 2000

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there an Excel function or technique to count occurrances of cells with a particular font color?
I received a spreadsheet in which the status of various elements if represented by colors and would like to automatically count and total them.

1 reply

by tlang

Found the answer on Microsoft's web site. Font Color is a property that can be tested using a Visual Basic macro. Several examples in Knowledge Base showing how to use various font and cell properties within Excel.

This discussion is closed to new replies.