Excel filtering
 

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

Thanks!

Excel filtering
 

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!

Excel filtering
 

XL-2007: yes, older version: No


"Deb Simon" wrote:

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

Thanks!

Excel filtering
 

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!