Sorry about the trivial title but...



I need to be able to compare to figures in different cells, and if one is larger than the other fill the cell with a red background.

Something along the lines of

if cell a1 is greater than cell b1
then
make a1 red
else
make cell a1 green

I will need to copy the same formula in to other cells too.

Thank you.