Excel 2007 : IF Formula / Macro to switch order of cells

hi,

sorry if this question has already been addressed.

I would greatly appreciate if someone could help me set up a formula to rearrange the order of cells if the value in one cell is greater than in another.

EX:

A1 = "Team 1"; B1 = "25"; C1 = "Team 2"; D1 = "30"

how would you write a formula or macro that would swap A1 with C1 and B1 with D1 if the value of D1 is greater than B1?

I learn quick but am not an Excel pro.


many thanks.