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.

Conditonal Formatting will do that easily for you.

>Format>Conditional Formatting

From the toolbar menu


Corey....

"EriccW" <(E-Mail Removed)> wrote in message
news:AA157B1D-6E2C-49C5-A422-(E-Mail Removed)...
>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.