Comparing Values from One Cell to Another
 

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.

Comparing Values from One Cell to Another
 

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.