If Then Syntax to Color Cells Depending on the Condition 'Value' - possible?

I am a VBA beginner and am struggling with the following:

I have a series of 25 values (in this case, names) which I need to use as triggers to colour cells 25 different colours. Eventually I will have 100 worksheets that all need to have the same 25 'trigger values'. I have been trying to learn and use the If...Then and If...Then...Else syntax's to get this working and am struggling with even the most basic code (below). Nothing happens when I run the below marcos. Any help would be appreciated.

Please Login or Register  to view this content.

Hi, as a new member, you should have looked at our rules. Specially at the one about quoting program code which MUST be enclosed between brackets. At the beginning of your code, you open a bracket [, you write CODE and you close the bracket ]. At the end of your code you open a bracket [, write /CODE and close the bracket ]. Then, you'll be all set to get an answer to your thread.

You should be able to modify it

Here is your macro modified to work.

Please Login or Register  to view this content.

I can see that this is just the beginning.
Hope this helps.

Try this:

Please Login or Register  to view this content.

Try this macro:

Please Login or Register  to view this content.

Change the range in the first FOR NEXT loop from A1:A19 to suit your application.
This is a lot easier to manage and maintain.

I saw those names in your list of names: samh, samg and sam. Be aware that "sam" will always be found in "samh" and "samg". If you place "sam" at the beginning of your array, it will not interfere with the other two. But at the end of the array, it will change the color of them both.

If you only have those characters in your cells and that they are always written the same way (no capital), you can use this IF statement instead and it will make the difference between sam and samh or samg.

Please Login or Register  to view this content.

I hope this will help you
Regards

Try this macro:

Please Login or Register  to view this content.

Change the range in the first FOR NEXT loop from A1:A19 to suit your application.
This is a lot easier to manage and maintain.

I saw those names in your list of names: samh, samg and sam. Be aware that "sam" will always be found in "samh" and "samg". If you place "sam" at the beginning of your array, it will not interfere with the other two. But at the end of the array, it will change the color of them both.

If you only have those characters in your cells and that they are always written the same way (no capital), you can use this IF statement instead and it will make the difference between sam and samh or samg.

Please Login or Register  to view this content.

I hope this will help you
Regards