I'd like to run a macro based on a cell value being higher than another cell value

[sharmon]

Hi,

So i have two cells E27 & E28. Both cells are numeric.

E27 has a formula that changes based on some other cells inputs.

If E27 has a higher value than E28 i'd like to run a macro.

Else nothing should happen.

I'm sure this should be simple but i just can't get it to work.

Any help would be great! thanks!

 

[steve the fish]

Its a little confusing what you are doing when you mentioned another sheet as your Macro1 makes no mention of sheet references so excel will use the activesheet. Maybe if you put your workbook into dropbox and send the link ill take a look.

 

[sharmon]

I found this code somewhere, it works fine but only responds to a numeric value in E27, whereas i have a formula in E27. Do you know how to change it to make it work? I think i was unnecessarily complicating things with macros.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$E$27" And IsNumeric(Target) Then
If Target.Value > Target.Offset(1, 0) Then
Target.Offset(1, 0) = Target.Value
End If
End If
End Sub

 

[steve the fish]

As you have found that doesn't work for formula. You could use that for an input into a formula if you understand me?

 

[sharmon]

Sorry, i don't understand