Change font colour of certain words on sheet

[Tyrannis]

I'm trying to change the colour of a few words on my sheet to red. A quick search online finds this:

Please Login or Register  to view this content.

However, this will only change the colour of one word. Is there a way of modifying this so I can change the colour of multiple words to red?

[sintek]

Hi Tyrannis...

Welcome to the Forum...
Can easily be achieved...2 points before we can assist...

Your post does not comply with Rule # 2 of the Forum Rules found here
2. Programming code must be enclosed in code tags to improve readability. (A, Z)

Please Login or Register  to view this content.

So...Edit your post...Highlight the code and press the # button

It is easier to offer a solution if you supply a sample file depicting your before | after requirement

[Tyrannis]

I've edited the post to comply now

[sintek]

Thank you...

This will give you an idea...
See attached file and run code...Code is set to color multiple words red

Please Login or Register  to view this content.

[Tyrannis]

This worked perfectly - thank you!

[sintek]

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Thanks.gif