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

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

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