Can a Function determine the color of a cell or the text in a cell?

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

You are looking for Conditional Formatting. It's on the Format dropdown menu.
Write in a formula that has either a true or false result (such as =A1>A2) and then set the format conditions and if the formula result is true, the formats occur. The down side is you are restricted to 3 situations (formats)

Let us know if you have problems.

ChemistB

You guys are awesome... as usual.