Take a look at Format|Conditional formatting.

(You can't change the font color using formulas in your cells.)

John wrote:

I'm trying to write a formula for my spreadsheet that has the
following logic:

If current value (column G) is greater than value located in (column
D), then change the font color to green. If not greater, then change
the font to red.

For example, Cell G4 has a value higher than D4, so I'd want it green.
Cell G5 has a value less than D5, so I'd want it red.

Any ideas?

Thanks in advance.

--

Dave Peterson