I use a spreadsheet to record answers to a test. Each cell the answer is
recorded in looks to another cell with the correct answer. All wrong answers
cond. format to red background. Is there no easy way to have Excel count how
many cells are being conditionally formated to give me their score? I tried
http://www.xldynamic.com/source/xld.....html#counting but my cell
value always returns #name? I'm using Excel 2007.
--
Ken


"macropod" wrote:

Hi kmaki,

There is no worksheet function to count cells based on their colour. You'll need to build your formula using the same logic that you
used to determine what colour the cells should be.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"kmaki" wrote in message ...
How do I countif where cells are conditionally formatted to either "yes"
(formatted to change fill to yellow) or "No'(formatted to change fill to
orange"

The end result is for the # of yes and the # of nos.

Thank you.