Hi,
You said you had 3 colours:
Red for negative
Blue and Back for positive.
In the Conditional Formatting:
What condition did you use to achieve black font?
What condition did you use to achieve blue font?
What condition did you use to achieve black font?
Is one of the font colours the default colour?
Dave.