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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eehinmd - 16 Mar 2006 17:38 GMT

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?

Reply to this Message

AndyB - 16 Mar 2006 17:46 GMT

Hi

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

Andy.

>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?

Reply to this Message

eehinmd - 16 Mar 2006 18:09 GMT

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

> Hi
>
[quoted text clipped - 9 lines]
> > fill
> > is red. IS there a way to set the fill value to a variable to count with?

Reply to this Message