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

Quote:
Originally Posted by Moideen View Post
Hi,

Please help me to get count of colored excel Rows

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

When opening the file Need Message How many rows are colored

Please Help me.
I think counting cells based on bacground colour has to be done with VBA. Try this:

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