Comparing Values from One Cell to Another

E

EriccW

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use BeforeDoubleClick to place 1 or 4 character in a cell 1
Conditional Formatting with VBA 4
Can a formula do this? 1
Comparing images? 2
VBA Conditional Formatting .IconSets plus one other icon/symbol 14
Conditional format if difference in cell values greater than 0.50% 1
Conditional Formatting to Another Cell 0
Arrays and scattered cell values or another way? 16

Top