Hello All,
I often use colored cells to filter by column. For example, column A may have 30 cells colored blue, then i can easily filter by that color to get those particular cells in Column A.
But wonder if I want to do the same filter technique with colored cells, only by Row, instead of by Column.
For example, if Row 2 has some cells colored, then how can i set a filter on Row 2, to just filter for those individual colored cells?
Thanks for the help
I often use colored cells to filter by column. For example, column A may have 30 cells colored blue, then i can easily filter by that color to get those particular cells in Column A.
But wonder if I want to do the same filter technique with colored cells, only by Row, instead of by Column.
For example, if Row 2 has some cells colored, then how can i set a filter on Row 2, to just filter for those individual colored cells?
Thanks for the help