View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Moideen View Post
Hai,

Please help me to get count rows of coloured.

Data Having 125 Rows, Row No : 50 and Row No : 75 are coloured with blue

Need MSG on Row1 "2 Rows are colored" is there any function in excel 2007 for this.
You'll be needing a "User Defined Function" then...

Try this.
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm