Change colour of text

Hi Deirdre

Thank you for your question

I suggest using the conditional formating tool.

1.Select the range of cells to format
2.Go to format and conditional formating
3.For condition 1 select less than and type 0 into the value box
4. Click on Format button and set the font format to be blue
5. Click Add to add another condition
6. Choose equal to and type in 0. Set format to black
7. Add another condition
8. Here the condition is greater than 0 and the format is red

Regards

Stephen