If cSign = OldcSign Then Set bgColor For Rows In Columns B,C,D,E,F,G For cSign AND OldcSign As FF0000 End If Where aSpace = OldaSpace Then If aSpace = xyz+ Where x Is (81,82,83,84,85,86,87,88,89,90,91), y Is (CA,CB,CC,CD,CE,CF,CG,CH,CI,CJ,CK,CL,CM,CN), z Is (1,2,3,4,5,6,7,8,9) Then aSpace1 = aSpace + (Left 1 Up 1 From aSpace) + (Up 1 From aSpace) + (Right 1 Up 1 From aSpace) + (Right 1 From aSpace) + (Right 1 Down 1 From aSpace) + (Down 1 From aSpace) + (Left 1 Down 1 From aSpace) + (Left 1 From aSpace) If 0 < minAlt < 30000 In aSpace1 Then If OldminAlt < minAlt < OldmaxAlt In aSpace1 Or If (OldminAlt - 1000) < minAlt < OldminAlt In aSpace1 Or If OldmaxAlt < minAlt < (OldmaxAlt + 1000) In aSpace1 Then Set bgColor For Rows In Columns B,C,D,E,F,G For cSign AND OldcSign As FF0000 End If End If If 0 < maxAlt < 3000 In aSpace1 Then If OldminAlt < maxAlt < OldmaxAlt In aSpace1 Or If (OldminAlt - 1000) < maxAlt < OldminAlt In aSpace1 Or If OldmaxAlt < maxAlt < (OldmaxAlt + 1000) In aSpace1 Then Set bgColor For Rows In Columns B,C,D,E,F,G For cSign AND OldcSign As FF0000 End If End If End If If aSpace = xyz Where x Is (81,82,83,84,85,86,87,88,89,90,91), y Is (CA,CB,CC,CD,CE,CF,CG,CH,CI,CJ,CK,CL,CM,CN), z Is (1,2,3,4,5,6,7,8,9) Then aSpace1 = aSpace If 0 < minAlt < 30000 In aSpace1 Then If OldminAlt < minAlt < OldmaxAlt In aSpace1 Or If (OldminAlt - 1000) < minAlt < OldminAlt In aSpace1 Or If OldmaxAlt < minAlt < (OldmaxAlt + 1000) In aSpace1 Then Set bgColor For Rows In Columns B,C,D,E,F,G For cSign AND OldcSign As FF0000 End If End If If 0 < maxAlt < 3000 In aSpace1 Then If OldminAlt < maxAlt < OldmaxAlt In aSpace1 Or If (OldminAlt - 1000) < maxAlt < OldminAlt In aSpace1 Or If OldmaxAlt < maxAlt < (OldmaxAlt + 1000) In aSpace1 Then Set bgColor For Rows In Columns B,C,D,E,F,G For cSign AND OldcSign As FF0000 End If End If Set bgColor For Rows In Columns For aSpace1 As FFFF00 End If End Where OldminAlt < minAlt < OldmaxAlt 2000 = OldmaxAlt 1000 = minAlt 0000 = OldminAlt 0000 < 1000 < 2000 (OldminAlt - 1000) < minAlt < OldminAlt 1000 = OldminAlt 0001 = minAlt 0000 = OldminAlt - 1000 1000 - 1000 = 0000 0000 < 0001 < 1000 OldmaxAlt < minAlt < (OldmaxAlt + 1000) 1000 = OldmaxAlt + 1000 0999 = minAlt 0000 = OldmaxAlt 0000 + 1000 = 1000 0000 < 0999 < 1000 OldminAlt < maxAlt < OldmaxAlt 2000 = OldmaxAlt 1000 = maxAlt 0000 = OldminAlt 0000 < 1000 < 2000 (OldminAlt - 1000) < maxAlt < OldminAlt 1000 OldminAlt 0999 maxAlt 0000 OldminAlt - 1000 1000 - 1000 = 0000 0000 < 0999 < 1000 OldmaxAlt < maxAlt < (OldmaxAlt + 1000) 1000 OldmaxAlt + 1000 0001 maxAlt 0000 OldmaxAlt 0000 + 1000 = 1000 0000 < 0001 < 1000