My boss asked me to look into this ... so no pressure or anything ...
I need to be able to sort cells based on color conditions.
Example to explain my needs:
column1 [fruit]----------column2 [#]
---------------------------------------------------------
Apple ----------------------2 (Highlighted Red Cell)
Grape ----------------------2 (Highlighted Purple Cell)
Apple ----------------------1 (Highlighted Red Cell)
Lets say that I need to sum up the amount of Apples (in column2).
Since this sheet is continuously being added to, it would be nice to be able to sum up the highlighted rows. How do I do this?
I hope this makes sense ... Thanks.
Bookmarks