I have some calculations to find the percentage of the sum of some figures, This can be a negative percentage I need to have these figures in Red I have tried Cond Formatting to say if less than 0 then text is red but this does nothing what am I doing wrong