I am trying to update my Quality control charts with some basic trend analysis. I need to be able to easily track trends in Spike, blank and standard results using excel 2010. Using conditional formatting I have been able to track 7 consectutive increasing or decreasing points:
=AND(O4:O9>O3:O8)...