Conditional formatting + macros

I have a large set of data that contains both negative and positive values pulled from a macro. There are several zero values, but only because the data isn't currently available. I can't just delete the zeros, because I still need the formula, in case the information becomes available.

The problem: I'm using a 3-color conditional formatting to show the bottom 10% and top 10%. But the zeros skew the formatting, because they all show red and take up the bottom 10% red formatting.

Can I have the conditional formatting apply to all cells except zeros while still calculating the percentiles?

The custom format is great! Except the conditional formatting still picks up the "values" and colors the cells red. The >0 idea won't work, because there are negative numbers as well. I will work on posting an example!

Actually, no example necessary. I added an if function and it is now leaving zeros blank (it's just pretty nasty and long). Thanks for the ideas!