I have a column in Excel containing approximately 12,000 records.
However, I only wish to isolate those cells which are shaded in a particular colour. The rest can be deleted.
As I understand it, this cannot be done in Excel but can be done via VB code. Any ideas ?
Thanks all
I have a column in Excel containing approximately 12,000 records.
However, I only wish to isolate those cells which are shaded in a particular colour. The rest can be deleted.
How do I do this ? Tried 'Find cells that match a format' but no joy.
Thanks all
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.