For loop through a row help

[learner99]

Hi I could use some help with a for loop.
I want to loop through a row and when I hit Saturday and Sunday I want to highlight that column.
I figured out how to do the compare and do the highlighting. I'm now just stuck on the loop.

Here is an example of my data:
Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday,Monday,Tuesday,Wednesday,Thursday, etc

The row that this is on is row 2

Here is the code I have so far:

Please Login or Register  to view this content.

Thanks again

[protonLeah]

Is there a reason why you don't use conditional formatting?

[learner99]

This is just one small part of a huge macro that has a bunch of processes.

I was able to get a working for loop I am still stuck on how to incriment the cell to the next column

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[learner99]

Thank you! That was exactly what I needed.
Have a Great Day!