Counting Coloured Row

[Aslam]

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

 

[Bernard Liengme]

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