Change the font color based on value of cell

[Robin]

How do I get excel to change the font color based on the value in the cell,
e.g. 1 3 5 change font color to red, 0 00 change font color to green

 

[Gary''s Student]

Use Conditional Formatting.

See:

http://www.contextures.com/xlCondFormat01.html