Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by EVANSY
-
Isolating cells with shading
Many Thanks to you besto1a that has worked Think I will check if my local library stocks that particular book- EVANSY
- Post #5
- Forum: Microsoft: Office
-
Isolating Excel cells with particular shading
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- EVANSY
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Isolating cells with shading
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- EVANSY
- Thread
- Replies: 6
- Forum: Microsoft: Office
