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.