how do I start a macro using If Then statments

[acspollock]

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

 

[Mike H]

Hi,

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

=if(a1>10,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

 

[Gord Dibben]

You don't need a macro.

Use Conditional Formatting.


Gord Dibben MS Excel MVP