Unfortunately that code does not work due to the DisplayFormat property, which is not present in Excel 2007 (this line of the code

Code:
If mergedRange.DisplayFormat.Interior.ColorIndex = 15 Then
As stated in my original post, I need to ensure compatability with 2007 due to not all users having 2010 installed (me being one of them).