I'm putting together a form which I'm looking to prescribe certain actions dependent upon the response of the user.

The Start point is that rows 14, 15, 16 and 17 are hidden.

in essence I'm looking for scripts to determine the following:

Permanent
If C12 = "Permanent"
Row 14 = "Hidden" and Cell C14 = "31/12/2099" (Don't ask, it's the default value from HR).

Temporary
If C12 = "Temporary"
Row 14 unhidden and Cell C14 Mandatory (must be in date format)

Contractor
If C12 = "Contractor"
Row 14 unhidden and Cell C14 Mandatory (must be in date format)
AND
If C12 = "Contractor" AND D14 <= 28
Unhide Row 15 and 16
If C12 = "Contractor" AND D14 >28
Unhide Row 15 and 16 and 17

I'm sure it doesn't make a difference but I'm determining the value of C12 by use of radio buttons.

Any help is much appreciated.

Regards

Terry