VBA in Excel to control cell value
I'm making a SS for some teachers that lets them track how the kid's grades are doing compared to their targets (conditional formatting with a Vlookup on a grade boundary table). They've not asked for the feature I want to include, but I'm going to try it anyway. What I want to do is make a bit of code, or an IF statement if that's simpler, that provides a prompt if the teacher enters a mark that's higher than the maximum (e.g. they put 5 when the top mark is 4). I've got a basic idea of how it should look, something like "IF the value of cell x is greater than y, then do pop up warning", but it's been so long since I've used VBA.
If anyone else has been able to do this or can do this and can shed some light, I'd be eternally grateful :D