How To Make Validation Text Give Different Error Messages

In of my tables called Employee Payroll, I have several earnings fields, and in a previous post I mentioned that I have implemented a validation rule for them which is £2.50 or £2.75 or £3.10. I have also used an error message in Validation Text to help the user if they enter an invalid value.
How can I change this message to reflect what the user types in? For example, if they enter an erroneous value like £9.34, the error message would say, "You have entered an erroneous value" or if they type an extreme value like £3.40 or £0.01, the error message would say, "You have entered an extreme value".
I understand that I would need to state when the data becomes erroneous and when it becomes extreme- so I thought, anything above, £4.00 should be erroneous and any negative values too. Extreme data would be anything between £0.00 and £3.10.
Would I need to use some kind of code in VBA?
Thanks