I have the following conditional formatting applied to a row of cells:
Formula is =MOD(ROW(),2)=0 (put border top and bottom)
Cell Value is > =AVERAGE($E2:$IV2)*1.3 (apply blue type)
Cell Value is < =AVERAGE($E2:$IV2)*.7 (apply red type)
Now I have the same conditioning applied to all the rows of data. Most places it is working just fine. The top line of where I have it applied is not working though. If I insert a blank row above it, it works fine. I don't want to insert a blank row though. Why is it behaving this way and is there an alternative fix?
Formula is =MOD(ROW(),2)=0 (put border top and bottom)
Cell Value is > =AVERAGE($E2:$IV2)*1.3 (apply blue type)
Cell Value is < =AVERAGE($E2:$IV2)*.7 (apply red type)
Now I have the same conditioning applied to all the rows of data. Most places it is working just fine. The top line of where I have it applied is not working though. If I insert a blank row above it, it works fine. I don't want to insert a blank row though. Why is it behaving this way and is there an alternative fix?