Loop through workbook and apply conditonal formatting based on previous sheet

**beenbee** · 07-07-2016, 11:46 AM

Hi All,
I don't know if this is possible. I have attempted to adapt my code for the same thing, but referencing a sheet with a set name. But no joy, it loops throught the workbooks but doen't apply the formatting. I think this is due to the referencing in the formula.

Any Thoughts?

Please Login or Register  to view this content.

Thank you!!

**Richard Buttrey** · 07-07-2016, 12:41 PM

Hi,

Change the two lines

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**beenbee** · 07-08-2016, 06:30 AM

Hi Richard,
Works a treat. Thank you so much!

Beth

Loop through workbook and apply conditonal formatting based on previous sheet

LinkBack

Thread Tools

Rate This Thread

Display

Loop through workbook and apply conditonal formatting based on previous sheet

Re: Loop through workbook and apply conditonal formatting based on previous sheet

Re: Loop through workbook and apply conditonal formatting based on previous sheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Loop through worksheets and apply conditional formatting

[SOLVED] Conditonal formatting based on text in cell, then highlight entire row

[SOLVED] Loop and apply formatting

[SOLVED] Excel 2007 : How to apply conditional formatting to cells based on their previous cell value.

Conditonal formatting based on adjacent cells

Conditonal Formatting a Cell Based on Other Cells

Conditonal formatting based off date&time

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions