Like the title states I am looking for a means to find all rows that have a colored cell. My clients do not maintain any one color when setting a cell background. I am working in Excel 2007 and am aware of the sort columns by color and also have played with some VB to look at individual colors per column, but I was asked to find a means to sort all records to find ANY row with a cell that has a color.
Thanks
Bookmarks