Use defined Tables. When a whole column of defined Table contains same formula (or same format or Data Validation rule), whenever a new row is added, the same formula (or format or rule) is added into new fields of this column.