Hi Forum,

I am stuck on a problem with a formula.I am wanting to summarize an RSI chart into a cell by highlighting it Green for a rising RSI from 30 to 70 and when it falls below 70 to 30 the cell turns red. My problem is that the formula has to know when it reaches above 70 and accordingly realise that if it goes to lets say 51 it is going down and not up.

Any questions or ideas will be greatly received