Hide Rows based on cell color

Hello


I've created a named Range ("VRange") in column V16:V600

Within this range I have numerous cells with the color Red.


I would like to create a button which hides all the rows, within this range, that are non-Red color (Leaving only the Red showing)


Is there a way to create a macro without using conditional formatting?


Thanks for any help

Jeff

Outstanding..


Thanks, Simon!




May ask a follow up question?

If the "VRange" contained various colored cells, but I only wanted to show the green colored ones how could your code be modified to accommodate this...?

thanks again!

Jeff

Thank you very much, Mr. Noob


worked great!


Jeff