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:
Any help would be great!
Thank you.
Bookmarks