Hi


I am trying to apply a conditional format to 40 rows and infinite columns

Here is my code
F16:XFD16 apply red color higher than E16, apply green lower than C16

But the problem is
I try to apply this as only rising 16 to 17,18,19 but the conditional stay 16 all the time

I created same rule at the 17th row but this time it became 16-17-16-17
I need to make it like 16-17-18-19 by moving the cross on the left side.
Thanks

Secoo, I don't know what you mean by applying that condition "as only rising 16 to 17,18,19". Are you saying the conditional formula is looking at row 16 all the time, rather than the current row (whatever it is)?