You can't directly filter on colors. You need to use a VBA function to
return the colorindex number of the cells, and then filter on those values.
See www.cpearson.com/excel/colors.htm for more details about returning a
colorindex value to a cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"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/