Macro to find & edit table cell background based on text

QuietLife · #1 03-03-2023, 01:59 AM

Hi,

I've found some articles similar to my issue but I simply cannot get them to work as I need them to.

I would like to run a macro that finds/replaces the mail-merged results of a series of student report attributes. I'd like the colour of the cells within the table to be one of 5 colours based on the contents.

I've uploaded an example of the output (just one record, the finished article with have around 300). It demonstrates the ranges of results I'll be hoping to 'conditionally format'.

Please can anyone help me? I'm sorry if this has been resolved successfully already but I couldn't find a solution when I tried to search for one.

Thanks in advance!

QL

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find Text - traffic light cell background color	oddworld	Word VBA	2	04-19-2022 03:40 AM
Macro to find a header based on a value in another cell	Tphil413	Excel Programming	2	07-23-2019 09:59 AM
Find and Replace rows in a table based on bold text.	OfficeAssociate99	Word VBA	4	07-26-2017 07:20 AM
VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color	jc491	Word VBA	8	09-30-2015 06:10 AM
Word VBA Macro to Find and Replace based on the Alt Text of an Image	bennymc	Word VBA	1	01-27-2014 04:23 PM