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

Hi,

You can't have an if statement along the lines of

=if(a110,this macro,that macro)

but you may be able to do it with worksheet_Change by monitoring the cell
that causes your cell to become 10 but conditional formatting sounds a much
better option.

for example this is a conditional format formula in a1 and looks at a2 and
as soon as A2 is 10+ than a1 there is a colour change

=$A$2-$A$1=10

Post an example of what you are trying to achieve and you will get more
precise help

Mike

"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

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