Don't display #DIV/0! and #VALUE!

I've redacted and attached my spreadsheet for assistance please.
Is it possible to make it so the Divide by Zero and Value errors do not display?

I have both formulas and conditional formatting here. The rate columns are pretty simple. It's a basic percentage based on the column before/the AA column. If Data Field is less than 49% of the monthly goal, it should turn RED. If greater than or equal to 90%, it should turn GREEN. If between 50%-89%, it should turn AMBER. This seems to work, as does the formula. However, not all rows will have a goal.

Is there any way to state that formatting only occurs if there are values in both the month column and the AA column. Otherwise, I'd like the rate column to either do nothing and be completely blank, or change to a dark grey color (not sure if that's possible, but that would be ideal).

I'd be so appreciative if someone more skilled in Excel than I could please take a look and recommend some formulas.
Thank you in advance!

That works to remove the #DIV/0!, but it turns the cell green. Is there any way to stop it from turning green that you know of?
Thanks so much!