I would be grateful for some help please.

I use an IF function to write a "1" in the cell:

=IF($C$15>$A20,IF($C$15<$A22,1,0),0)

I wish to retain the "1" in the cell once the condition has reverted. I don't want it to go back to "0".

Everything I have tried ends up as a circular reference.