Hide Cell(s) in list based on Color.

[garretonufer]

Hello,

I have a list created with over 1200 rows.

The list is a compilation of 3 seperate lists with duplicates.

each list is represented by its own color, (yellow, orange, green)

I want to create a check box for each color that will Hide the cells represented by that color.

Can someone give me some pointers here?

much appreciated.

[Palmetto]

Try the attached and modify as required. It uses option buttons linked to a cell.

Please Login or Register  to view this content.

[garretonufer]

I've tried to copy your macro and adjust accordingly, but haven't had any luck. I've attached the file, if you wouldn' tmind taking a look. Thank you.

[garretonufer]

Nevermind, I'm using your file, and inserting my data. I don't fully understand the macro, but now have some idea. Thanks for the help.