Conditonal Formatting will do that easily for you.

FormatConditional Formatting

From the toolbar menu


Corey....

"EriccW" wrote in message
...
I would like to compare the values of a cell to the cell before and after
it.
The qualifier is I need to see the difference as a color based on whether
the
value is more than 9 over or less than the previous cell:
i.e.
Cell Value Result
C1 18 no change
C2 8 cell color is yellow
C3 16 cell color is green

I know this requires a Macro, but I'm not sure where to start in creating
this.