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

[ooos9272]

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.

[p24leclerc]

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.

[ooos9272]

Thanks, I'll restart the thread

[p24leclerc]

You should be able to modify it

[ooos9272]

edited now, fingers crossed for help!

[p24leclerc]

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.

[ooos9272]

Definitely a help. I have simply tried to increase the Range to cover multiple cells and am coming up with an error. Can anyone tell me why?

Please Login or Register  to view this content.

[p24leclerc]

Try this:

Please Login or Register  to view this content.

[ooos9272]

Thanks for the help so far. I'm definitely getting somewhere with the code. I'm trying to use this same code on another worksheet (i will need to use it on 100 worksheets eventually) but when I try to do so I get an error, and the error states that I need to de-bug the following

Please Login or Register  to view this content.

My understanding was that if you don't specify which worksheet a code chain is for, then it works on whichever worksheet you have open...?

Here is the full code I am currently using:

Please Login or Register  to view this content.

[p24leclerc]

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

[p24leclerc]

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

[ooos9272]

Thankyou again for your help, I worked around this problem by adding a button to each page - this seems to be doing the trick, and I did not need to change my code.

Thankyou very much, I do appreciate all your help.