If a cells value is greater or less than the value of another cell then run macros

Hello,

I already have this code which runs a macro when the target cell is changed and it works, but what I need it to do is:

If A6 value is greater than cell E7 then run macro1
If A6 value is equal to cell E7 value then do nothing
and if A6 cell value is less than E7 value then run macro2.

What do I need to add to the below code to achieve this? Any help would be appreaciated thanks.

Great forum btw!

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Thank you John that's exactly what I was after. It works great

Thanks for the replies both work great.

You're welcome. Glad to help out.