See: http://www.cpearson.com/excel/colors.htm

Need help with VBA? See David McRitchie's site on "getting started" with
VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Aslam" wrote in message
ps.com...
hi

I have large data consisting of around 500 rows. Most of them are
highlited with colour; I would like to count coloured cells only. Is
there any function or macro to support solve this problem

Looking for your guidence

thanks
aslam