hii everyone,

i need a formula that automatically changes the font color of a cell i.e

A B

1 12 56
2 45 63
3 98 101
4 7.70 7.75
5 35 32
6 67 66

my question WHEN ENTERING DATA IN COL B1, IF A1>B1, FONT COLOR BLUE

IF A1<B1, FONT COLOR GREEEN.

CAN SMN PLZ CLARIFY ME ON THIS ITEM. THANKS