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