ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   filter by colour cell (https://www.excelbanter.com/excel-discussion-misc-queries/71095-filter-colour-cell.html)

Filtering on colour cell

filter by colour cell
 
A lot of spreadsheets are colour coded per cell. Would make it a great deal
easier to be able to filter on these colours rather than scrolling down.

----------------
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...lic.excel.misc

Peo Sjoblom

filter by colour cell
 
Next version of Excel will have this implemented and using SUBTOTAL and this
filtering you can also sum and count by colour.

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Filtering on colour cell" <Filtering on colour
wrote in message
...
A lot of spreadsheets are colour coded per cell. Would make it a great deal
easier to be able to filter on these colours rather than scrolling down.

----------------
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...lic.excel.misc


Ron de Bruin

filter by colour cell
 
See EasyFilter or wait for Excel 12
http://www.rondebruin.nl/easyfilter.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Filtering on colour cell" <Filtering on colour wrote in message
...
A lot of spreadsheets are colour coded per cell. Would make it a great deal
easier to be able to filter on these colours rather than scrolling down.

----------------
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...lic.excel.misc




All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com