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