use data validations for that
suppose u have two fields
field1
field2
field2 is required only if field one has "yes" value.
on field2 rightclick and click data validation -> Add
field1 is equal to Yes and
field2 is blank
then enter the tip .. and click ok
now this field will be required if field1 = Yes