I'm looking for a macro that notifies a Excel WB User that two numbers are not =. In the attached mock up, the "Imputed Tax Rate", calculated by dividing Income Tax by Net Sales, is different then the "Effective Tax Rate" which is entered as a number in a different cell.
I am trying to notify the user by a text box, a message or "comment" that only shows when the User selects the Effective Tax Rate Cell, or hovers the cursor over it (In the Mock Up, cell M19). The only other conditions are; if the numbers are "=" there is no need to display the notice. If the Income Tax cell is -0- or blank, the Imputed Tax Rate is then also -0- and may be displayed as compared with the Effective Tax Rate.
Hopefully this is an interesting challenge! And as always, "thank you" in advance!