Hi Please help,
I have a row of values which updates daily, I then also have a upper limit say of 10 and a button limit of say 5.
As soon as a number in the row of values go beneath the bottom limit then the conditioning formatting must activate.
I need the conditional formatting to check the daily value when it is below the bottom limit, it must check the previous days value and if it is more than the previous day it need the cell fill color changed (say red). The number must stay red until it is over the upper limit and more then the previous day.
Hope this make sense.