It is possible, not very efficient, if you have a means of determining
which you picked to color red that would be better. Colors are
hard to distinguish by simply looking at them especially on a laptop,
but then that might be your problem in itself.
The following is not for those assigned color by Conditional Formatting.
Set up a helper column and read the following
http://www.cpearson.com/excel/SortByColor.htm
you want to use a filter instead of sorting. Hopefully the entire cell
is colored the same. It is possible to color each letter differently
in text.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"maximilian" wrote in message ...
Hey guys
is it posible to filter on color? so lets say I want all texts that is
colored red to be filterd in a certain column.
is that posible?
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/