Need Values < than and > from columns into A3 & M3 respectively

When any cell in Column J, Range( J4:J76 ) is clicked I need this revPrice in M3 cell, if Values in H is less than 90 & greater than 80 then I need to get the percentage of Product of Values H & M and subtract that with value in G

Please Login or Register  to view this content.

& when any cell in Column D Range( D4:D76 ) is clicked I need this revPrice in M3 cell

Please Login or Register  to view this content.

Can someone help me to code this in Selection Change Event of the Worksheet, attaching the file for your reference, I have highlighed mock work in Column N & O in Sheet "NIFTY"
Other codes in Selection Change Event as below should not be a hindrance in the above work

Please Login or Register  to view this content.

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...ugh-macro.html