Reply To: HELP! Automating text formatting and GREP questions

You can change text by image:

1/ Place the image in your document (in the pasteboard for example)

2/ Manipulate the image so it looks the way you want (size, rotation, fill, stroke…)

3/ Cut it

4/ Open the Find/Change dialog box and choose the text tab

5/ In the search field, type your text, here “yes”

6/ In the replace field, click on the @ then Other/Pasteboard content (not sure of the wording, I'm working on a french version). So you must see “^c” (sure for that)

7/ Click Replace All

8/ Done

Don't forget you may not see the images if the height of the rows are too small!

As it is NOT a grep style, this is not automatic :(

But as you can save this request, you can reapply it as many times as your client will update the excel file.

Hope it will help you