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
Categories:
So how do you sort by actual color?
[…] out how many rows are colored on an Excel spreadsheet can be unbelievably frustrating. This video shows you how to do it and save you hours of aggravation. @Pilchy was ready to put a shotgun to […]