Unable to make negative numbers in Calc display red

Since upgrading to LO 4 I haven’t been able to make negative numbers in calc show red. I can tick the ‘Negative numbers red’ box in the Format Cells/Numbers dialog, and sometimes the number will show red in the drop down format list. The cell may or may not change colour. If it does, when I save and close the spreadsheet then reopen it, the negative numbers are no longer coloured.
Is there any suggestion that might solve this for me?

I’m using the latest version of LibreOffice and MS Windows 10 fully updated. Using the latest procedure in LibreOffice Calc I cannot negative numbers (currency) display in red. Today is May 24 2016. Help please.

Already discussed here 4.0 Calc cell format problem - clean install on XP Pro