Hi All,

I"m looking to flag data if the last 14 data points in a row (column actually) have been following an up and down pattern. I only need the last cell in the series to be flagged. So if, A14>A13, A13<A12, A12>A11, A11<A10....A1, then A14 will turn red. Also would need to work for the inverse (A14<A13, A13> A12...). Any ideas on how to compress this in my conditional formatting? I was trying to work with COUNTIF's but couldn't get it to work.

Thanks in advance

ChemistB