I'd like to know if there is a way to have a function determine the color of a cell. For example I have 3 cells (a1,a2,a3). In A1 I have the number "3" and in A2 I have the number "4". Now I want the cell A3 to turn red or green depending on whether A1 > A2.

The only thing I can think of would be to use an =if function like "=if(a1>a2,"a3 turns green","A3 turns red")"

If there is some way to do that I'd sure like to know. It would help me out a lot.

~Erin