Hi Dot,

See xlDynamic's ColourCounter page at:

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


---
Regards,
Norman


"dot" wrote in message
oups.com...
I'm new to VBA & I need help to:

count number of cells of based on the background color & value in
cells.
color of cells can be red, orange, yellow, green & no color.
each of these cells contain value which can be K1, K2, K3, P1, P2.

what I need in the end will be something like:

green & K1 = ?
green & K2 = ?
green & k3 = ?
green & p1 = ?
green & p2 = ?

yellow & k1 = ?
yellow & k2 = ?
& so on...

orange & K1 = ?
& so on....