Vba: Selecting table cells by fill colour

effimera · #1 10-24-2021, 12:40 PM

Hi there,

I was wondering if it is possible to create a macro that selects table cells with a specific fill colour.

In MS Word, I've got a table with 4 fill colours. The table extends over 300 pages, and I would need to select only two colours (if one at a time, that's OK, but the quicker the better), then to delete them.

I tried an alternative procedure by using Excel:
copy & paste > apply Filter by Colour > delete
However, this method is unsatisfactory in that Excel automatically sets the List and thus some unique numbers as General, resulting in a recalculation with entirely different numbers/codes (such as 8,15381E+11 instead of 815381020338 or 5.V instead of 5/5).

Therefore, I'd much prefer to use a macro in Word, if that's even possible.

Thanks a lot!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
New table line has some cells fill colour change	trevorc	Excel	2	06-30-2021 12:27 PM
Text box fill colour changes when pasted to new file	ParishPete	Publisher	0	06-21-2019 12:47 AM
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only	mag	Excel	0	10-28-2012 08:04 PM
How to fill a font colour to a particular data appear so many times in a column?	PRADEEPB270	Excel	0	03-22-2012 02:04 AM
Accessibility Display & Colour Fill in Shapes	thorn	Office	0	08-11-2011 07:58 AM