Sub Calculate() only works for one column, any ideas

this code works for Rng but not Rng1. Tried every combo (except the right one) Columns just have numbers within range or out of range.
the ranges are a calculated average of three preceding columns. So, it looks like this.
column f column O
Column c, column d, column e, average Column L, column m, column n, average
0.2524, 0.2526, 0.2525, 0.2525 0.0123, 0.0143, 0.0133 0.0133

column f works good, the right color in the right cell, Column 0 is all over the place cell that have 0.055 will come in red, cells the have 0.12 come in yellow

Any help would be appreciated.

Please Login or Register  to view this content.