Using If to apply color

[cvilla714]

Hello I am trying to use If to apply color to a range base on the text inside.
so the first part of the code I wrote I got

Please Login or Register  to view this content.

now I am trying to run a loop but I can't make it work.

Please Login or Register  to view this content.

can someone please help me figure this out .

[CK76]

You are using i to loop, but you are not using it in the internal logic.

As well, you've already set myrg as range object. You don't need to nest myrg within Range().

i = 1 is redundant as you are specifying range of i's to iterate over (1 to 10).

So something like below would work.

Please Login or Register  to view this content.

[jeffreybrown]

Give this a go

Please Login or Register  to view this content.

[Rick Rothstein]

Here is another way to do it without using a loop...

Please Login or Register  to view this content.

[salim ali]

Try this macro

Please Login or Register  to view this content.

[cvilla714]

Thanks a lot for the replies, they all work great, I just have one more question, is it possible to use the same color from the cell that was colored to the rows that goes from columns A to column F and going down?
if so , what needs to be tweaked in order to do it ?
So put it like this, I already got the cell colored on column A can I apply the same color the rest of the cells from column A to F?
Thanks again for the replies.

[jeffreybrown]

In my example...

Please Login or Register  to view this content.

[CK76]

Just add resize to the cell range to color.
A-F = column size of 6. So...

Please Login or Register  to view this content.

[cvilla714]

Yes, thanks a lot this is what I was looking for .

[jeffreybrown]

You are very welcome and thanks for the feedback. We are all happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[CK76]

You are welcome and thanks for the rep.

If your question is answered, please mark the thread as solved, using thread tool found at top of your initial post.