Thanks for the response. I wish I understood how to do it! I assume it is
using VB, which I unfortunately know little about.

Thanks for your time.

"Biff" wrote:

Hi!

A "best practice" would be to craft a formula based on the logic of why the
cells are colored rather than count cells that are colored.

But to answer your question, see this:

http://xldynamic.com/source/xld.ColourCounter.html

Using the count color method has a "bug". Changing a cells color does not
trigger a calculation so the resultant formula will not update a color
change until a calculation is triggered either manually or by some other
event.

Biff

"dwae2000" wrote in message
...
Hello.

I am hoping you can answer an excel question for me. I'm using excel to
track a schedule. I'm not sure if it was the best program to use but I
don't
want to switch now. Is there a formula that will count how many boxes are
shaded a particular color? For instance every blue shaded one is equal to
15
minutes.

Thanks.