out of limit data

C

cjmiller

Certain readings are recorded daily in my excel data. I need to know
how to identify data cells that are outside of 10% of the average for
all the data.

Any help is appreciated

Thanks,

cjmiller
 
G

Guest

Hi
I selected the range (D12:D24) and I used Format/Conditional Format. Change
the option from Cell Value to Formula Is and put this in:
=OR(D12>(AVERAGE($D$12:$D$24)*1.1), D12<(AVERAGE($D$12:$D$24)*0.9))

It works for me!
Andy.
 
Top