Click on any image to enlarge

Conditional formatting is used extensively as a visual guide to quickly indicate when invalid entries have been made.
When GDS and TDS limits have been exceeded.
When pre-payment and payment increase limits have been exceeded.
When an incorrect date has been selected.