Use conditional formating. click on the 1st 4 in the 2nd row. In the Fomat
Menu select conditional formating

this assumes the data is in rows 1 & 2.

enter in condition 1
=IF(A1A2,TRUE,FALSE)
select format and in Pattern select red
Press OK

Select Add
enter condition 2
=IF(A1<A2,TRUE,FALSE)
select format and in Pattern select blue
Press OK

Select Add
enter condition 3
=IF(A1=A2,TRUE,FALSE)
select format and in Pattern select black
Press OK

Now you have to copy the conditional format. with the 1st 4 on row 2
highlighted select the paint brush on the tool bar. Now highlight columns 2
- 4. The conditional formating should be on all cells on row 2 columns 2 - 4.
"m.sparks" wrote:

I have 2 rows of numbers: 2, 3, 5, 4
and 4, 3, 4, 5
I want to format the numbers in second row to display in red, if it is
greater than the number in the first row (in same column), in blue, if it
less than, and in black if otherwise.
Please help. Thanks in advance.