Macro to find & edit table cell background based on text
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
|