View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EriccW EriccW is offline
external usenet poster
 
Posts: 1
Default 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.