Hi all! I have a spreadsheet that each cell is formatted to change the fill color based on the value in the cell. I have a legend to the side showing which fill colors contain which values. I would like for when I select let's say the yellow filled cell in the legend, all of the yellow filled cells will be selected. I have searched for the answer with no luck. I'm hoping someone can help