Value based on cell formatting

[jmoffett]

I have a grid that shows which departments (listed in rows) have turned in inspection forms (listed in columns). If the department has turned in a particular inspection form, I format the cell at that intersection green.If not, I format it red. I would like to assign a zero value to red cells, and a value of 1 to green cells. That way I can quickly showed the percentage of inspection forms that have been turned in based on the total number of green cells. Can this be done and, if so, how?