Is it possible to have a code that counts coloured cells?
 

I am using excel as a tracking matrix, and want to be able to count all blue
cells for my stats.

Can anyone help?

Much appreciated,
Fiona

Is it possible to have a code that counts coloured cells?
 

See Chip Pearson's site about this:
http://www.cpearson.com/excel/colors.htm

Mike F
"Fiona" wrote in message
...
I am using excel as a tracking matrix, and want to be able to count all
blue
cells for my stats.

Can anyone help?

Much appreciated,
Fiona

Is it possible to have a code that counts coloured cells?
 

Hi Fiona,

Complete solution at

http://www.xldynamic.com/source/xld.ColourCounter.html
Processing Coloured Cells

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fiona" wrote in message
...
I am using excel as a tracking matrix, and want to be able to count all
blue
cells for my stats.

Can anyone help?

Much appreciated,
Fiona

Is it possible to have a code that counts coloured cells?
 

Hi Fiona,

You will Find these Very Helpful :-

http://www.cpearson.com/excel/colors.htm
http://www.ozgrid.com/VBA/Sum.htm
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

All the Best.
Paul


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Is it possible to have a code that counts coloured cells?
 

Great Information Bob,
I will Add it to My List.
All the Best.
Paul



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!