or
http://www.xldynamic.com/source/xld.ColourCounter.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Norman Jones" wrote in message
...
Hi Sheeba,
See Chip Pearsons colour functions page at:
http://www.cpearson.com/excel/colors.htm
---
Regards,
Norman
"sheeba" wrote in message
oups.com...
Hello!
Is it possible to count the nuber of rows in a range with interior
color (any)
for eg. on range "B1:F20" if any cell in B1:F1 got interior color count
it and check next row B2:F2 ... like wise and count the number of rows
in the range having atleast one cell with interior color.
thanks