 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007Advance Filter can be based on cell Color in Microsoft Excel
In MicroSoft Excel, Advance Filter (Data->Filter->Advance Filter) feature can be enhanced. New feature that we can introduce is to do Advance Filter based on Font/Highlighted Color. e.g. If in excel I have 10 Rows and 3 rows font color is RED and 7 rows font color is GREEN then using Advance Filter option we can apply filter based on Font Color or Highlighted Color. In Excel 2007 this is possible now You can try my Filter add-in for older versions http://www.rondebruin.nl/easyfilter.htm  SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > In MicroSoft Excel, Advance Filter (Data->Filter->Advance Filter) feature can > be enhanced. New feature that we can introduce is to do Advance Filter based [quoted text clipped - 12 lines] > > http://www.microsoft.com/office/community/en-us/default.mspx?mid=999c5cf4-7a35-4 14c-94c9-af63aa7bf0bf&dg=microsoft.public.excel.newusers I love it when this happens <bg> SignatureRegards, Peo Sjoblom > In Excel 2007 this is possible now > [quoted text clipped - 24 lines] >> >> http://www.microsoft.com/office/community/en-us/default.mspx?mid=999c5cf4-7a35-4 14c-94c9-af63aa7bf0bf&dg=microsoft.public.excel.newusers |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.