This one requires that the VP column be populated when the Tier column = “Tier 3”
Rule type = Validation.
isNullOrEmpty({Self}) && Tier==”Tier 3″
This one hides the VP column when until “Tier 3” is selected.
Rule type = formatting
Tier != ‘Tier 3’