I’ve created 7 styles to use with conditional formatting in 17 adjacent columns. The 7 styles are assigned to the 17 columns in series: 1-7, 1-7, 1-3. The first 7 columns show styles 1 to 7 as a charm when the condition is meet. Columns 8th to 17th, all of them, show style 7 when condition is meet, despite they are set with styles 1 to 7 and 1 to 3. It doesn’t make any sense. I’ve checked all settings: all seems OK, but it doesn’t work as expected for columns 8 to 17.
Can someone put me in the right direction to solve this?