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.

1 total post (Page 1 of 1)  
| 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.

Back to Community Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums