I have an excel spread sheet were the some of the rows are set on conditional formatting based on some criteria. What is the easiest way to filter out the coloured rows without having to go row by row and hiding the uncolored rows. I have over 1000 of rows with data.
can any one help
thanks,
Bookmarks