Need help looping through multiple sheets to conditionally format the same range/sheet

In my experience, you will need to select both the sheet and the range where you want to add the CF, much as you would in "real life".

I generally define a worksheet variable and set it to the Active Sheet. Then, when you've finished your loop you can restore the original sheet. Use ScreenUpdating = False.


Regards, TMS