You don't need a macro.

Use Conditional Formatting.


Gord Dibben MS Excel MVP

On Mon, 5 May 2008 00:34:00 -0700, acspollock
wrote:

how do I start a macro using If Then statments

I want to be able to change font colour to amber when difference between
values is less than ten and change it to red if the values are equal or value
2 is greater