In a nutshell, I'm looking to know what the standard methodology is for coding user defined criteria (such as Excel's conditional formatting)

For example, let's say I have a commission system with...