How to loop through sheets with Range(Cells and apply conditional formatting

Dear all,

I'm a bit stuck. Hoping someone can help.

As part of a calendar I'm making I'm trying to loop through the sheets and apply some condtional formatting.

Every sheet is a month, but I can only seem to apply the conditional formatting to highlight bank holidays and weekends to the first sheet "January".

Looping through the sheets and I can add other values without issue.

Please Login or Register  to view this content.

It seem you can't use ActiveWorkbook.Worksheets(c) before Range(Cells... , but it's a problem for me because I'm using Cells to find the last rows (LastRow) and last columns (LastCol)

How can I add the below to either the loop or to all the sheets in the workbook.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks all.

You have numerous lines such as:

Range(Cells(5, 3), Cells(LastRow + 2, LastCol)).FormatConditions.Add

and

With Range(Cells(5, 3), Cells(...

that, since they are not qualified (not inside a With..End With block), apply to the active sheet, whatever that may be.

---

Your code should look something like:

Please Login or Register  to view this content.

Hey RuairiO,

Can you post your full code or better yet attach sample file as it is difficult to understand where you're struggling.