Community

General discussion

Locked

Excel 2000

By tlang ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Font Color Property

by tlang In reply to Excel 2000

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.

Related Discussions

Related Forums