I think field specific highlighting (that overrides color coding) would be a must for this type of validation, otherwise it would a) complicate/collide with existing color coding and b) be ambiguous to identify what’s causing the failed validation
As a bonus, field specific highlighting (to indicate required columns, for example) would also allow for adding another feature of making it easier to differentiate between input and calculated columns 