Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Advance 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. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.newusers |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Advance Filter can be based on cell Color in Microsoft Excel
I love it when this happens <bg
-- Regards, Peo Sjoblom "Ron de Bruin" wrote in message ... In Excel 2007 this is possible now You can try my Filter add-in for older versions http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Prateek Singhal" <Prateek wrote in message ... 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. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.newusers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
excel should allow me to filter rows on basis of the cell color | Excel Worksheet Functions | |||
How do I filter based on color in Excel? | Excel Worksheet Functions | |||
In Microsoft Excel 2003, when I select a color for a cell it does. | Excel Worksheet Functions | |||
How Do I change the background color of a cell in microsoft excel. | Excel Discussion (Misc queries) |