Recommendation - apply cell formatting to negative numbers

To highlight negative numbers in red, apply the cell formatting in the cell number property instead of the font color. If the data changes, the cell remains red if it is applied as red to the font, but reverts to black if the negative number format is applied.