Hi,
1000 row spreadsheet cols A:L
Wish to filter to only see rows which contain a fill colour. There is only the 1 fill colour orange on the sheet.
Is there a none VBA way to do this? E.g. if wanted to do the same but for blanks, irrespective of random column blank is I'd use =COUNTBLANK( in a helper column.
Many Thanks
Gareth
1000 row spreadsheet cols A:L
Wish to filter to only see rows which contain a fill colour. There is only the 1 fill colour orange on the sheet.
Is there a none VBA way to do this? E.g. if wanted to do the same but for blanks, irrespective of random column blank is I'd use =COUNTBLANK( in a helper column.
Many Thanks
Gareth