Loop through worksheets and apply conditional formatting

[beenbee]

Hi All,

I am trying to loop through a workbook and apply conditional formatting based on data in Sheet 2 in my workbook, to sheets displaying data imported from csv files.

The issue I am having is, the conditional formatting is applied to one sheet multiple times, x1 for each of the worksheets in my workbook. I can't seem to work out how to fix it, I have looked at a lot of posts and I seem to be doing what others are.

The loop seems to work as the MsgBox I have added lists the sheets in the workbook, but only applies the conditonal formatting to the sheet the macro is run from.

One final though, is it possible to exclude say sheet 1 and sheet 2 from the loop?

Here's the code I have:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any help would be great!

Thank you.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[beenbee]

Hi John,
Thank you very much for your reply. I have tested it out this morning, thank you for showing me how to set the range, rather than using selection. However the problem still presists. The conditional formatting is all applied to the sheet from which the code is run, so in my test book 4 times, and is not aplied to any of the other sheets in my workbook. Any ideas?

Thanks you!

[beenbee]

Hi John & All,
I managed to fix what was going on, with a For Loop. Here is the code, for anyone else who may get stuck on this.
(As a note, the code also skips the first sheet)

Please Login or Register  to view this content.

Thank you for the help, set me on the right track.