I have an excel file that is color coded. There are over 3000 rows some colored white, some green, yellow, etc. Can I filter the file by color? If I only want to see the rows colored yellow. Is there a way to do that?
maybe - or what you could do is add a column with a numerical ID# unique to each colour (use a find/replace, and replace all blank yellow cells with a yellow cell w/ #1, etc) - then filter on those.
http://www.digdb.com/excel_add_ins/sort_custom_text_length_color/ Here’s an add-on that’s supposed to do the trick