First, you had about a hundred CF rules on the C276 Percentages sheet - FYI I have removed these in the attached workbook.
As you want different formatting for each pair of cell columns then there has to be separate CF rules for each pair if columns.
Here is the formula for F3:G10
Here is the rule for I3:J10:
The formula for the additional column pairs is similar - the only change is $G3 >> $J3 >> $M3 etc.
In the attached file I have implemented these formulas and your required formatting for F:G and I:J.
Let me know if I have understood your requirement correctly. If so then I will leave it to you to complete the remainder of the column pairs!
Bookmarks