Is there a way to read an colored Excel cell and keep a count of that color?

Topics: Developer Forum, Project Management Forum, User Forum
Jun 26, 2012 at 5:56 AM

I have a project in which I am to read an excel spreadsheet.  I am to keeping a count of how many cells are colored red, yellow or green in a column.  For example, if a column that have 10 rows with 4 green, 2 red, and 4 yellow. By using PHPExcel, I can keep a count of which cell is red, yellow, or green. 

Coordinator
Jun 26, 2012 at 7:54 AM

Is this using conditional formatting? or simply standard cell formatting?

Jun 26, 2012 at 2:25 PM
MarkBaker wrote:

Is this using conditional formatting? or simply standard cell formatting?

It is both conditional and standard cell formatting as there will be multiple worksheet involved.