VBA code to hide rows with certain color

Need some help here. I want to auto hide rows for certain color (green to be exact). Can anyone help me out with the code for this.

Originally Posted by Richard Buttrey

What is giving rise to the colours. Are they from a conditional format or is there some other unique characteristic that relates to a colour, or are they rows you have manually coloured?

Rows that I manually color

so try this:

Please Login or Register  to view this content.

i used this sub to get the interior color (which i thought was vbGreen but it was not) so verify that you are using the correct number for the color

Please Login or Register  to view this content.

It worked. Thank Much