Is there a way to count cells in a range based on fill color?

I have a workbook that uses the fill color as a dimensionof the data (
currecy of training). I want to automate statistics without counting cells
and entering the number. I would like to do some thing like countif the fill
is red. IS there a way to set the fill value to a variable to count with?

Hi

Have a look here for some help:
http://www.cpearson.com/excel/colors.htm

Andy.

"eehinmd" <eehinmd@discussions.microsoft.com> wrote in message
news:8ADF68B2-862A-4EEF-B596-C764344F94EA@microsoft.com...
>I have a workbook that uses the fill color as a dimensionof the data (
> currecy of training). I want to automate statistics without counting
> cells
> and entering the number. I would like to do some thing like countif the
> fill
> is red. IS there a way to set the fill value to a variable to count with?

Thanks for the tips. This seems to be what I was looking for.

"AndyB" wrote:

> Hi
>
> Have a look here for some help:
> http://www.cpearson.com/excel/colors.htm
>
> Andy.
>
> "eehinmd" <eehinmd@discussions.microsoft.com> wrote in message
> news:8ADF68B2-862A-4EEF-B596-C764344F94EA@microsoft.com...
> >I have a workbook that uses the fill color as a dimensionof the data (
> > currecy of training). I want to automate statistics without counting
> > cells
> > and entering the number. I would like to do some thing like countif the
> > fill
> > is red. IS there a way to set the fill value to a variable to count with?
>
>
>