Can you filter by color? Ether font color or fill color?

Thanks!

Hi Deb

Is possible in 2007 but in older version not, but you can try my add-in for older versions
http://www.rondebruin.nl/easyfilter.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Deb Simon" <Deb wrote in message ...
Can you filter by color? Ether font color or fill color?

Thanks!

XL-2007: yes, older version: No


"Deb Simon" wrote:

Can you filter by color? Ether font color or fill color?

Thanks!

In pre-2007, you can only sort by color, not filter by color, and you need
code to do this:
http://www.cpearson.com/excel/SortByColor.aspx

HTH,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Teethless mama" wrote:

XL-2007: yes, older version: No


"Deb Simon" wrote:

Can you filter by color? Ether font color or fill color?

Thanks!