How to Count or Sort Rows by Color

@Pilchy had a reporting emergency and called for help on Twitter. @getreport help has responded with this training video.

Click here to get the Visual Basic code e-mailed to you.

If you’ve had a spreadsheet with many rows colored and other rows left uncolored, then you realize that there is no easy button to sort or count rows that have color. This can be a very time consuming process, unless you use Visual Basic. Here’s one solution that we’ve come up with.

To get a copy of the VB code used in the video, Sign up here

This entry was posted in Best Practices, Excel, Video and tagged , , , , . Bookmark the permalink.

2 Responses to How to Count or Sort Rows by Color

  1. Jaffe says:

    So how do you sort by actual color?

  2. Pingback: OLAP – The Business Intelligence Podcast [BIP] | Business Intelligence Reporting Community

Comments are closed.