MS Excell Problem?
Can i filter a column, according to the colour of the lines?
- sal the dogLv 61 decade agoFavorite 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.
Cheers!Source(s): I took a class in excel (ok, three of them)
- WhodamanLv 41 decade ago
No, unless you compose a macro you can only filter data that has been typed into a cell