Afternoon.
On my worksheet i type in values but when i type REFUND "only ever in a column C cell" the text is automatically turned red & also in the row in question at cell D i see in red £0.00
I then continue to enter the refund value in this cell so when i type £50.00 it then turns to -£50.00...