changing cell total colour

[cuckooca]

Hello all. Im fairly new to Excel. In my document i have a cell that totals a minus sum (e.g $-200.00)

I would like the colour of that sum to be colour red automatically and then turn back to black when it becomes a plus amount again.

Is there some way of telling Excel to do this  for me.

[#2 · Accepted solution]

@cuckooca Use Conditional Formatting. Select the range of cells where they may be negative, click Conditional Formatting on the ribbon/Highlight cell ruls/Less than 0 and choose the Fill and/or Font color as you wish (you can take their defaut Light Red Fill with Dark Red Text font). 

[#3]

@hynguyen  Thank you so much . That did the trick.

[#4]

@cuckooca 

As variant is custom number format as