MS Excell Problem?

Can i filter a column, according to the colour of the lines?

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Do you mean the color of the rows? You have some color assigned to the rows, to sort out some unrelated bit of information regarding the data therein?

    Unless you have written a macro that takes the data and assigns a color based on it. (i.e. gender - 1=male, 2=female ... male = blue, female = pink ) (if you follow) there is a data element that determines the color of the row, so you might be able to sort on that.

    If, however, you have just assigned colors (as I suspect you have) then I do not think it is possible to sort on that... I'm pretty sure it has to be a data element of some sort - in order to sort.

    sort of.

    Cheers!

    Source(s): I took a class in excel (ok, three of them)
  • 1 decade ago

    No, unless you compose a macro you can only filter data that has been typed into a cell

Still have questions? Get your answers by asking now.