Cell Toggle to Show and Hide Rows in the Active Sheet

[kkorp]

Hello all, New Guy Here
I hoping to get some feed back here on a spreadsheet that I use to track an outside consultant remote installation of current software and new programs. I use a Legend as a guide line for the order of importance. (See Graphic) The first column is used for the group color. I'm not sure if its possible the use the colored cell as a toggle to show / hide the rows in the spreadsheet. I would like to be able too Click on to cell to show the colored rows and a second click to hide that content, just like a toggle.

Any help or thoughts would be greatly appreciated.

Thanks

 

[kkorp]

I tried the code again, its trying to do something but doesn't seem to be finding the color of the select cell color. I flashes but none of the rows hide or unhide.

 

[kkorp]

I have tried to figure out why the code isn't hiding the row of the selected cell in the legend, but my experience is limited but I did notice it flashes and selects cell D1.

Thanks for your help