Cell colour changes, locked cells.

[Guest]

I recently asked how to change a cell colour when my stock level fell below a
min stock value. This has been very helpfully answered. Thank you all.

But , if I use the "Formula Is:= and click on the cell it enters as $A$1
which means the cell is locked. But, when I add or delete stock lines (rows)
understandably the cell reference won't change.

Is there a way to stop the cell entering as $A$1 and instead enters as
simply A1?

Thank you

CD01

 

[Guest]

I have the same problem sometimes. My work around is to go back into the
conditinal equatin and remove the $s