SharePoint : How to make a field mandatory based on another field, in a datasheet list view?

You can use List Settings -> Validation Settings for this.

e.g. =IF([Replacement Available]="Yes",IF([Replacement]="",FALSE,TRUE,TRUE)

This formula would affect the default 'new item' form as well.