I think you can do that with the conditional formatting option.
I have Excel 2007 and there is a conditional formatting button on the main bar, select that and you then can select the conditions and the colors you would like the cell(s) to change when the value changes.
|