Hi Charles. I've attached a redacted file here. To clarify a bit, hoping to run a conditional formatting function as an on off button that I can apply to several sheets in my workbook, all of which are modeled the same as this file attached. For each cell(C4:N15), I will ask the function to look at its respective variance(comparing its value to column Q) and if that absolute variance is greater than the average absolute deviation(column R), then it should be highlighted for review. make sense?
thanks for having a look. greg
|