"Kelly Lim" wrote:
.....
How bout i have other cells in other colour?
like yellow, green, and cells
with no colour?
are there any formula to do so which i can
make it automatic to count too?
There contain no conditional formatting
.....just manual fill in colours...

For the above, you need to use a UDF (VBA), for example Bob Phillips'
ColorIndex UDF. Pl re-look the many responses given earlier in this thread /
branches: the link to Bob's page, the steps to implement Bob's UDF, a nice?
sample file with the implemented UDF to boot ... in all, a complete
"starter's kit" so as to speak. I've got practically nothing left to give
you but this response .. <bg
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----