Here is example
Column E is formatted to show minus figures in red. When I add info for next day it does not hold format

SAMPLE.xlsx