Trend search

[jpen]

Hi all,

I have a worksheet with in column D the yield of a process. Now I want to add a trend search. If 3 values in a row are having a lower yield then there should be an alarm (message box or color change of cell, etc.)

I want to do this without using macro's.

Any idea's

JH

 

[PaddyD]

" If 3 values in a row are having a lower yield then there should be an alarm..."

Which of these would generate an alarm:

6;5;4;3
6;5;4;4
6;5;2;4

?

 

[jpen]

The following trneds should give an alarm:

6;5;4;3 alarm on 4 and 3
6;5;4;4 alarm on first 4
6;5;2;4 alarm on 2


JH

 

[jpen]

I have put in the next conditionel formatting. But the first empty cell at the end of the column is also red colored.

Formula = AND(B5<B4;B4<B3)


Any idea how to optimize the formula.

JH

 

[jpen]

Some error in formula


Formula = AND( B5 < B4 ; B4 < B3 )


JH

 

[jpen]

Add another formula to the conditional formatting

Rule 1 = A6="" action cell no fill
Rule 2 = AND(A6 < A5;A5 < A4) action cell fill red


JH

 

[JustinWWolcott]

For what its worth, here's my $0.02;

Have your cell turn red when it drops below a rolling average.

In cell $A$1, put a 6 (it'll be a 6 cell rolling average)


then, for cell C7 set up the conditional formatting formula equal to this:
=C7<AVERAGE(OFFSET(C7,-$A$1,0,$A$1,1))