pop up box if cell >90%

[justvba]

Hi I am trying to figure out how to make this work. In column "F" starting at row 5 the managers enter a sale price for an item. In Column "I" I have a formula that is put in by a macro that will tell them the % of discount they are giving. they click on a button and the macro runs and pull a bunch of data and fill in some formulas in the spread sheet. I have a message box that tell them to check for any Discount % in red.

What I want to do now is when they go back and adjust the sale price if it is still out of line I want a message box to pop up and say "no" I thought I could do this by using data Validation but can't get it to work correctly.

sale price = Column F
% Discount = Column I

column f looks at column I and if it is >90% or <0% a message box pops up.

Can anyone help me???
Excel 2016

 

[kwp004]

Try this:

In a hidden column, input the formula: =IF(OR(I5>90%,I5=0%,),"XXX","")
In this example, I put this formula into cell K5.


Then, create a worksheet level change and use the following VBA:


Private Sub Worksheet_Change(ByVal Target As Range)


If Target.Address = "$F$5" Then
If Range("K5") = "XXX" Then

MsgBox "No", vbInformation, "Can't Do This"

Application.EnableEvents = False
Target.Value = ""
Application.EnableEvents = True

End If
End If


End Sub