=IF(COUNTIF(CA1A!C7:AD7,">0")=0," ",CA1A!AE7/(COUNTIF(CA1A!C7:AD7,">0")))

If this returns >500 then it is conditioned to turn green.

If this returns <400 then it is conditioned to turn red.

If it is zero it will return red, since it is <400, but I need it to stay blank.

For this formula to work in conjunction with another column which gives back the minimum, I need the above formula to use " " so that it doesn't take the 0 into account.

Any suggestions on how to have both of these functions work together?