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?

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

Hi

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

Andy.

"eehinmd" wrote in message
...
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?

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

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" wrote in message
...
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?