I have asked this before but have not got a clear answer I would really appreciate some help:
Situation:
I am creating a trivia game using excel 2003, I have various questions, pictures etc in which players are to type the correct answers into a cell. If they do the cells are conditionally formatted to turn a particular color. I want to keep a running total on each page as well as a total for all pages for the number of correct answers. I have tagged a cell with each answer to read yes if the correct answer is listed in that corresponding cell, that is counted (the #of yes) in formula in a cell at the top of each page, which works fine. The problem is that I have to do twice as much work to get these totals calculated than if I could simply have a formula in a cell that counts the color of the cells that are green(correct). there is a simple macro to count the number of cells with a particular fill color, but it does not count the cells that are shaded(pattern) that same color due to a CF being met. I believe there is a macro to do this through a macro in visual basic...or any other idea how I could do this in a much simpler way instead of having to format 2 cells for every correct answer.

Thanks hope for some help

Mike Lowrey