Hi again! First of all, thank you to everyone on this forum. My VBA skills have improved a ton since I joined.
I need to apply conditional formatting to the same range on 8-10 different worksheets with the workbook. Since the highlighting is based on comparing the value to a different cell for each worksheet, I am thinking I will have to code out each worksheets format conditions. You will see that all that really changes is the cell references under "define the rule or each conditional format" from $D$4 to $D$5 (there are 8-10 different cell references, one for each sheet). Is there a way to loop through the 8-10 worksheets, changing the format conditions to reflect the changing comparison value cell reference?
Code for Worksheet #1
Code for Worksheet #2
Bookmarks