View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie[_2_] David McRitchie[_2_] is offline
external usenet poster
 
Posts: 134
Default Filtering on Color

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/