I am using the following formula:
=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?
=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?