Hello, I’m a real novice & could do with some help.
The value of Fridays data is compared with Thursday - font & background will change colour depending on whether Fridays value is higher or lower. (conditional formatting working fine)
What I would like is for the related up or down data to increment +1 depending on whether Friday is higher or lower compared to Thurs. Each day I add a new Day column which I paste data into, each new day will be compared with the previous.
I have some small coding experience from way back, I was expecting to be able to put a formula into the up & down cells, something like this =IF(B2>=A2,D2=D2+1) Not so simple though. Any help or pointing in the right direction appreciated