How can I advanced Filter based on colour of cells?
An example would be
I have Cell C6, D7 and F8 being green.
Cell C7 is blue.
Say I want to advanced filter to only show rows that contain blue, resulting filter shows row 7.
Or say I want to advanced filter to only show rows that contain green, resulting filter to only show row 6, 7 and 8.
How would I go about doing this in excel advanced filters?
Bookmarks