return min and max values when there is #N/A in the range

You need to learn how to do it yourself. Get rid of any attempts you have made so far, then follow these steps in your own file exactly:

1. Select cell A1.
2. Open the CF dialog - create a new rule using the bottom option (formula).
3. In the formula box, type this: =A1=$H1
4. Choose your formatting.
5. Click OK.
6. In the Applies To ... box, type this: =$A$1:$F$34
7. Click OK.

Example attached.