Often we validate a field through a def procedure. I usually show an error message.
However, a message is quite intrusive, so I want to show a different background/font color for this field.
It would be nice if I can create a subroutine ‘validate iban number’ or - in my case - 'validate container number’.
This subroutine will output a 1 or 0 (valid or not), and in the Conditional formatting, I can then select 'type of value’ = subroutine, and then select the corresponding one.
If value = 0 - not valid, set the font to red.
Not sure of my train of thought is entirely correct, but you get the gist of it.
This way I can reuse the validation and easily show my user that values are not correct.
