It seems you are making it too complicated by addressing the
conditional format. You just need to use the formula that is used to
qualify cells for the conditional format to exclude them from the
average formula. You should be able to do that with a SUMPRODUCT or
other array formula.

Good luck.

Ken
Norfolk, Va

On Aug 6, 8:25*am, AHartong (donotspam)
wrote:
I'm trying to find the average of a range of cells that exclude points
outside the standard deviation of the cells. I found the standard deviation
and made simple conditional format (cells outside STDEV are in red) rules on
the cells outside of the range, but I'm not sure how to find the average
excluding the formatted cells.