Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering by Colour
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Filtering by Colour
Resolved · Medium Priority · Version 2003
Reply Wed 13 Oct 2010, 15:46Delegate David said...
David has attended:
Excel Advanced course
Excel Advanced course
Filtering by Colour
Hi,
Is there a way I can filter a list by the colours of the background cells?
For example, I have a list of 100 data entries, some of which are coloured in a red background. Is there a way I can filter out just the red cells in that list?
Many Thanks,
David
For upcoming training course dates see: Pricing & availability
RE: Filtering by Colour
Hello David,
Hope you enjoyed your Microsoft Excel courses with Best STL.
Thank you for your question regarding filtering by colour. It appears that you are using Excel version 2003 which unfortunately does not provide an easy way to filter by background cell colour. This could be done though using VBA programming. If you wish to find out more about this aspect of Excel, please contact our office by phone and we will be happy to help you with your enquiries.
Version 2007 & 2010 both allow for filtering by colour of font or cell background using the autofilter option.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
|