What version of Excel do you have?

This is for versions prior to Excel 2007.

Assume you want to apply this to the range of cells from A2:A10

Select the range A2:A10
Goto the menu FormatConditional Formatting
Condition 1
Formula Is: =AND(COUNT(A1:A2)=2,A2<A1)
Click the Format button
Set the font color to RED
OK
Click the ADD button
Condition 2
Formula Is: =AND(COUNT(A1:A2)=2,A2A1)
Click the Format button
Set the font color to GREEN
OK out

This assumes that you intend to enter values in the cells in sequence. Like:

A1, A2, A3, A4, A5 etc

Not like:

A1, A2, A5, A10

If intend to go out of sequence we'll need different formulas.

Biff

"Dave" wrote in message
...
Is there a way to have the text/font color change in a cell depending on
the
value entered?
For example: starting with cell A1, if I enter a value in cell A2 and it
is
a lower number than A1 can it dynamically change to red text? Or if the
value
in A2 is greater than A1 can it dynamically change to green text?

What I am trying to accomplish is enter multiple values in a column and
just
enter the number in each cell, A1, A2, A3... and depending on the value
comparison to the cell above, change the color of the cell contents. Is
that
possible?