For the range D$6$:E$6,$ create a custom validation rule to create a formula ensuring the driving leg is valid. For a driving leg to be valid both of these rules must be true:

a$.$ Start and end in one of the $27$ cities. City names are listed in the cities named range. Hint: use COUNTIF to check if the startinglending cities in D$6/$E$6$ match your named range. Section EX $12-7$e$,$ Insight.

b$.$ The total driving distance, stored in the dist named range, should not exceed $350$ miles.

If the validation rule is violated, display a warning box with the title Invalid Data and the message You either mistyped the city name or adding this leg will result in a total driving distance exceeding $350$ miles.